use select @ a = @ a + ... the writing tin be the outcome rows into columns displayed ,
Lacoste Trainers 2010
affirm @ a varchar (100),
Lacoste Trainers 2011, @ b varchar (100)
Select @ a = 'hxy, 9993,
Womens Lacoste Shua Trainers,0001, admin'
Select @ b =''
Select @ b = @ b +','+ ryxm from css_rydj Where CharIndex (',
Lacoste Protect Laser Trainers,'+ Rtrim (rybm )+',',','+a +',')> 0
select @ b
the terminal output is
,, ZS,
Lacoste Radiate Croc Trainers, Hong Xingyu ,
Lacoste Observe Strap Trainers, the system supervisor