apostrophe in an IN statement - TSQL

Question

Hello

In an IN statement I need to add people's full names:

IN ('will faulkner', 'liz taylor', 'martin p'smith')

The final name - martin p'smith - throws up an error because of the apostrophe in the surname. I tried to get round it by:

'martin p"smith' but that didn't bring through any data.

any advice please on how I can add a name with an apostrophe in an IN statement would be appreciated.

Thanks

Answer 1

Use two apostrophes instead of quotation mark: 'martin p''smith'.

Also note that there are more forms of apostrophes. Check that the table contains a simple one.