asked
Wild card search in execute sql task
Hi All, Is it possible to use like keyword in my execute sql task parameter ? example select value from table where column like '%?%'
Yes. But do it more like: > `where column like '%' + ? + '%'` Consider the fact that if you were doing this in T-SQL, you'd be doing something like: > `where column like '%' + @StringToSearchFor + '%'`
+1, just keep in mind that any index on the column cannot be used for seek. The table/index will be scanned when you use the % at the beginning of the string.
btw @Rob, welcome back! I read your chapter in MVP Deep Dives, interesting reading as always.
In normal situation it will not give you any kind of return value.
