I am using SQL Server 2000 and VS.NET 2005.
I need to write a stored procedure that accepts a parameter, say prmName, that can have a value like "Marks, Jones, Bondini". Basically the value is separated by commas.
I need to query the database for any possible combination of those comma separated values.
How can I do this?