SQLTeam.com | Weblogs | Forums

How to search for apostrophe character?

Afternoon all,

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

SELECT *
FROM testtable
WHERE testcolumn LIKE ''%'

Thanks

Dave

Try

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

Doh, thank you!