This uses CROSS APPLY and the fn_split() function to separate out parameters. The @vParam parameter stores your LIKE conditions, separated by commas.
Using TOP To Rank Columns In a Table
This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.
2011-10-25
6,509 reads