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
 Transact-SQL (2000)
 comma delmited parameter [RESOLVED]

Author  Topic 

cjonline
Yak Posting Veteran

55 Posts

Posted - 2009-11-05 : 08:22:33
Hi,
I wish to send a string parameter named @parameterlist like so:

12382,23465,21423

ie comma delimited string.

How can I split this string up in t-sql to use in the where clause ..
i.e


Select * from employee where employee_ref IN (@parameterlist)

cjonline
Yak Posting Veteran

55 Posts

Posted - 2009-11-05 : 09:28:52
Its ok folks.. I managed to sort it myself..
Go to Top of Page
   

- Advertisement -