I have VB create a Where clause that I want to pass to a stored procedure in SQL Server.

For example, @myParameter that I am passing in is ("A", "B", "C") and I want to say in my stored proc: Where item IN @myParameter.

Is this possible? It only seems to think that @myParameter is a single item and tries to match the whole string ("A", "B", "C") instead of "A" or "B" or "C".

Any suggestions?