Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: 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 you

  2. #2
    Join Date
    Jul 2007
    Posts
    3
    Hi,

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

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


    goodluck!

  3. #3
    Join Date
    Dec 2005
    Posts
    266
    wonderfull, and so easy :-)

    thanks a lot

  4. #4
    Join Date
    Jul 2007
    Posts
    3
    hi`, sometime everything become simple if we think it simple

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •