CSV String

Hi,

I have a variable like @.states=NY,VA,AL,CA.

Now i want to use the above string in the IN clause.How to separate those string and use.

Select * from xxx where @.State IN('NY','VA','AL','CA')

Thanks in advance

Here are a couple of pretty good references:

http://www.sommarskog.se/arrays-in-sql.html
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=326300&SiteID=1