Dear Gauri,

You will have to use a table valued split function to cater to this requirement.

A split function will take up the string as 'val1,val2,val3....' and a delimiter which will be "," in your case and provide you with ready to use value, which can be query using a simple select statement and passed in a sub query in your original query.

Here is a link of similar issue posted in a different forum.

http://dba.stackexchange.com/questions/21078/t-sql-table-valued-function-to-split-a-column-on-commas

Hope it Helps...!!

Kindly mark it as solution if it helped resolve your issue