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

Thread: Ask for replace

  1. 03-05-2001, 10:49 AM #1
    gabch
    gabch is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 03-05-2001, 03:36 PM #2
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  3. 03-06-2001, 02:52 AM #3
    gabch
    gabch is offline Junior Member
    Join Date
    Mar 2001
    Posts
    18

    Thn

    Dear sir,

    Thx your answer.


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width