/ Published in: SQL
This uses CROSS APPLY and the fn_split() function to separate out parameters. The @vParam parameter stores your LIKE conditions, separated by commas.
By Atif-ullah Sheikh, 2010/09/16
By Atif-ullah Sheikh, 2010/09/16
URL: http://www.sqlservercentral.com/scripts/SQL+Server+2005/71199/