Stored Procedure to return multiple inputs between commas
Posted on 2008-11-03
I would like to be able to take input from a user that is separated by commas:
Then i want to use the values in a where clause taken from a variable in a stored procedure.
I will make the variable nvarchar (4000) and use it in a like clause in a query. This way i can get multiple values from teh user. Sometimes they may use one or up to 10 values. What is the best way that i can accomplish this goal ?