String Manipulate in Stored Procedures

[JohnPham]

Hi All,

Any one have any idea how to make this work. I have a tring for example: "ABC, CDG, DGT" When I pass this to Stored Procedures as parameter, How do I make it looks like:
"('ABC', 'CDG', 'DGT')"

Thanks,

John

 

[clapag22]

To make it easier, the first thing I would do is do a replace any white space on the string:

select @var = 'ABC, CDG, DGT'

select @var = replace(@var, ', ', ',')

So now you have: 'ABC,CDG,DGT'

This will get you started:

while patindex('%,%', @var ) != 0

begin

print left(@var , patindex('%,%', @var) - 1))

select @var = right(@var, len(@var)-patindex('%,%',(@var))

end

print @var

Craig

 

[sunila7]

Hi,

Try this

Select '''' + replace('ABC, CDG, DGT', ', ', ''',''') + ''''

hope it helps....

Sunil

 

[JohnPham]

Sunil/Craig

Thank you very much. This help a lot.

John