Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Angry Unanswered: replace string help

    I need to replace the 45th position in a string of lenght 67 and keep getting syntax errors.

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    are you doing it in 4gl, store proc, or sed command?
    please post your code

  3. #3
    Join Date
    Nov 2004
    Posts
    2

    update position within a string

    I'm trying to do something like this:

    set priority = replace(substring(priority from 45 for 1), 'n','8');

    I'm not sure if I'm on the right track. Basically I want to replace whatever is in the 45 position with the value 8. The entire string is 67 long.

    I'm using SQL Editor to update an informix db.

    Thank you

  4. #4
    Join Date
    Nov 2004
    Posts
    26
    try using
    set priority[45] = 8

Posting Permissions

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