How to search for apostrophe character?

Transact-SQL
1

Afternoon all,

Just head scratching here, how would i search for the apostrophe or ' character

SELECT *
FROM testtable
WHERE testcolumn LIKE ''%'

Thanks

Dave

2

Try

SELECT *
FROM testtable
WHERE testcolumn like '%''%'

3

Doh, thank you!