Ask for replace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Ask for replace

  1. #1
    Join Date
    Mar 2001
    Posts
    18

    Lightbulb

    Dear all,


    I want to replace the 3th position of the string by "#".
    "abc123" -> "ab#123"


    best regards

    gab

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    gab,

    I think it is realy time for you to grab SQL Reference manual and learn a few basic things about character functions. I've given you a sollution for very simmilar question (on a diferent thread you started under the same title as this sone), however it seems that you don't learn very much from the answers to your questions. If you think others will solve any trivial task you stuck with, you won't get very far in this...

    Anyway, the answer to your question is:

    SUBSTR('abc123',1,2) || '#' || SUBSTR('abc123',4)
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2001
    Posts
    18

    Thn

    Dear sir,

    Thx your answer.



Posting Permissions

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


Click Here to Expand Forum to Full Width