Using a CSV input parameter within an IN() expression

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Using a CSV input parameter within an IN() expression

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-12 : 09:41:58

Matt Law writes "Hi,

I'll try and be brief with my description..

Our ASP/HTML applications produce CSV lists from multiselect dropdown boxes such as.. Sometimes, these CSV lists are alphanumeric i.e.

lilesa,lawm,wheelet,koonerp

I want to be able to pass this information into a T-SQL stored procedure as a single parameter and then in my SQL statement use the IN expression i.e.

Select * ... from .... where username in(@inputList)

where the @inputList is 'lilesa,lawm,wheelet,koonerp'

The obvious problems I am having is getting

'lilesa,lawm,wheelet,koonerp'

.. to become

'lilesa','lawm','wheelet','koonerp'

and getting this information into the in() expression.

Please help! I've been tearing my hair out over this one all day.

Many thanks,

Matt Law"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-12 : 09:41:58

Please, please, please read the FAQ. We have this exact question posted with an answer.