SELECT * FROM dbo.Table WHERE Text LIKE '%''%' AND Text LIKE '%"%'
SELECT * FROM tablename WHERE column_name LIKE '%''%' OR column_name LIKE '%"%'
ESCAPE
WHERE c1 LIKE '%10-15!% off%' ESCAPE '!'
select * from (select 'Zebronic''s' a) t where a like '%' + char(39) + '%' char(39) = ' char(34) = "
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)