How do I search for names with apostrophe in SQL Server?

SELECT     *
FROM Header WHERE (userID LIKE '%''%')

Double them to escape;

SELECT *
  FROM Header
 WHERE userID LIKE '%''%'

Related