SELECT Col1, Col2 FROM Table WHERE Col3 LIKE '%Value%'
Select allOpen in new window
SELECT Col1, Col2 FROM Table WHERE (Col3 IS NOT NULL And Col3 LIKE '%Value%')
SELECT Col1, Col2 FROM Table WHERE rtrim(Col3) LIKE '%Value%'
(Col3 IS NOT NULL And CHARINDEX ('Value', Col3)>0)
may perform better...
see http://cc.davelozinski.com/sql/like-vs-substring-vs-leftright-vs-charindex