Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,553
Community Members
 
Community Events
165
Community Groups

Where statement with apostrophe within value

Hi,

I am using Table Transformer macro with the SQL

Select * from T1 where T1.'Status' IN ("To Do", "Done", "Won't Do")

How do I include the apostrophe in "Won't Do" in the where clause? Thanks.

3 answers

1 accepted

Hi @Leona ,

Please try the following SQL query:

Wed 16-1.png

SELECT * FROM T1
WHERE T1.'Status' IN ("To Do", "Won"+ CHAR(39) + "t Do")

Wed 16-2.png

Hope this helps.

0 votes

Hi @Leona ,

try to use double ' 

Example :

Select * from T1 where T1.'Status' IN ('To Do', 'Done', 'Won''t Do')

Hi @Fabio Racobaldo _Herzum_ I tried the double '' did not work. :( thanks for replying.

0 votes
Benjamin Community Leader May 31, 2022

HI @Leona ,

 

If this is like SQL, you should be able to escape it. In this case, you maybe about to run single routes around the apostrophe.

 

-Ben

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

750 views 5 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you