dwain.c (12/20/2012)

---

vinu512 (12/20/2012)

---

dwain.c (12/19/2012)

---

Since quote is also CHAR(25), you can also do this:

CHARINDEX(CHAR(25), string_column) > 0

Single Quote is char(39) Dwain......if I am not wrong.

Looked like a single quote when I SELECTed it but then sometimes my eyes aren't so good.

SELECT N, CHAR(N) AS CharResult
FROM (SELECT TOP 255
      ROW_NUMBER() OVER (ORDER BY(SELECT NULL))
      FROM master.sys.all_columns sc1
      CROSS JOIN master.sys.all_columns sc2
      )a(N);

SELECT N, CHAR(N) AS CharResult
FROM (SELECT TOP 255
      ROW_NUMBER() OVER (ORDER BY(SELECT NULL))
      FROM master.sys.all_columns sc1
      CROSS JOIN master.sys.all_columns sc2
      )a(N)
WHERE CHAR(N) = '''';