Saturday, February 25, 2012

MS SQL 2000 string.replace

Hello
with the following query :
SELECT words FROM T1
i get :
A,B,C
how can i get
A > B > C
something like String.Replace(words , ',' , ' > ')
thank youHi,

you can replace SELECT words by SELECT replace(words,',','>')
your query become:

SELECT replace(words,',','>') words FROM T1

goodluck!|||wonderfull, and so easy :-)

thanks a lot|||hi`, sometime everything become simple if we think it simple :)

No comments:

Post a Comment