nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Where statement with apostrophe within value

Leona_y8vkcf

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.

Accepted answers

Katerina Kovriga {Stiltsoft}

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.

All comments

Benjamin_tmh9yg

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

Fabio Racobaldo _Catworkx_

Hi @Leona ,

try to use double '

Example :

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

Katerina Kovriga {Stiltsoft}

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.

Leona_y8vkcf

Thank you @Katerina Kovriga _Stiltsoft_ this works!!

Leona_y8vkcf

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

table-transformer