asked
detect "%e2%80%8b" in any column of a table
Anybody provide any hints to detect "%e2%80%8b" in any column of a table? Use patindex or ? any help appreciated
Do you want to find that exact sequence, or does the %-chara represent à wildcard aearch?
If you want to search for strings containing characters that would otherwise be seen as [pattern matching wildcards][1] (such as %), then you can use the ESCAPE keyword declare @MyTable table (col1 varchar(50)) insert into @MyTable values ('%e2%80%8b') insert into @MyTable values ('stufff%e2%80%8b') insert into @MyTable values ('%e2%80%8bstufff') insert into @MyTable values ('stuff%e2%80%8bstufff') select * from @MyTable where col1 like '%/%e2/%80/%8b%' escape '/' or escape each occurance within `[]` select * from @MyTable where col1 like '%[%]e2[%]80[%]8b%' select * from @MyTable where patindex('%[%]e2[%]80[%]8b%', col1) > 0 [1]:
http://msdn.microsoft.com/en-us/library/ms187489.aspx
