using varchar list with a select query

[yfatgo]

using the COALESCE function im creating a string to have a list of users sperated by a comma, now how can i use it in a sql select query ?

meaning :
I want to do a select query like that :
select * from tb1 where UserId in @UserList

where the UserList is the list i got with the COALESCE function.

 

[SQLSister]

These should give you some ideas
Passing a list of values to a Stored Procedure faq183-3979
Passing a list of values to a Stored Procedure (Part II) faq183-5207


Questions about posting. See faq183-874