Where statement with apostrophe within value

[Leona]

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.

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Leona ,

Please try the following SQL query:

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

Hope this helps.

[Leona]

Thank you @Katerina Kovriga _Stiltsoft_ this works!!

[Fabio Racobaldo _Herzum_]

Hi @Leona ,

try to use double ' 

Example :

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

[Leona]

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

[Benjamin]

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