Delimit with special characters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Delimit with special characters

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Delimit with special characters

    Hi

    If I have a record which is in a string of text (Eg: Today is a special day). If I need to add a special character like '!' for every encounter of the character 's' (Eg: Today i!s a !special day), is there any sql commands to do so??

    Thanks!

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    select replace('Today is a special day', 's', '!s') from dual

  3. #3
    Join Date
    Jan 2000
    Posts
    387
    Thanks!

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