select * from (select 'sdfs''asdf' as name)a where name like '%''%'

--即 用 like '%''%'

------解决方案--------------------
探讨

SQL code


select * from tbl where charindex(''',col)>0