Not sure what you mean, the following works as I would expect returning 1, 1, and 0, respectivelyDECLARE @x VARCHAR(32) = 'xyz'+char(39)+char(37)+char(95)+char(37)+char(39)+'abc';
SELECT CASE -- returns 1
WHEN @x LIKE '%'+char(39)+char(37)+char(95)+char(37)+char(39)+'%' THEN 1 ELSE 0 END;
SELECT CASE -- returns 1
WHEN @x LIKE 'xyz'+char(39)+char(37)+'%' THEN 1 ELSE 0 END;
SELECT CASE-- returns 0
WHEN @x LIKE 'xyzabc%' THEN 1 ELSE 0 END;
Like expression help
Posted - 11/07/2012 : 07:23:47
