Looking for how to code for an apostrophe in an IN: statement

[cbrotz]

How do I code an IN: statement with an apostrophe s:

IN:('LOWE'S');

The code above does not work.  

Thank you.

[cbrotz]

Looks like double quotes outside of the single works "LOWE'S"

[SASJedi · Accepted solution]

You can use two apostrophes in sequence like this:

where Store name IN ('LOWE''S','HOME DEPOT');

Or you can use double quotes for the outer quotes, like this:

where Store name IN ("LOWE'S",'HOME DEPOT');