Hi, I have to agree with Preethi about dynamic SQL.Manjuke, you could try something like this if you need to avoid the dynamic SQL bit in your example: Use a user-defined table-valued function that would break the string at the commas and return a table containing a single column of the values specified in @spParam This user defined ...