Looping Through Items in a String

[Kush]

I have a String which is a comma spearated list of values.
I now need to take each value from this string (while there are still values in the string) and use them in a query one by one. Essentially, I want to loop once for each value in the string. How can I do this?


Here's what I want to achieve...

set @my_string = 'john, lisa, matt, beth, stu'

for every item in @my_string
select *
from details
where name = (item in @my_string)

get next value...

I am not sure of the syntax...

I would appreciate any help.

Thanks a lot.

 

[MeanGreen]

Rather than using a cursor try this:

select *
from details
where name in (@my_string)

That will get you all your results.

Hope this helps.

 

[MeanGreen]

Just in case the previous example didn't make sense, I did this one against the Northwind database:


declare @my_string varchar(255)
declare @sqlstring varchar(255)
set @my_string = '4,5,6'

SELECT @SQLSTRING = 'select * from orders
where employeeid in (' + @my_string + ')'

exec (@SQLSTRING)



Hope this helps.

 

[Kush]

Thanks so much, MeanGreen!

 

[MeanGreen]

No problem.

Good Luck!