Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: newbie Update question

    forgive the rookie nature of this question...

    trying to do an update for values in a text column to append additional text string to each value, but obviously am not using the concatenation operator ( || ) correctly. here is what i tried:

    UPDATE table SET columnName = columnName || ' added string ' WHERE id = XX

    the result i get is that the matched columnName is reset to 0.

    thanks for any help,

    jgee

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    instead of '||', try,

    CONCAT(columnName, ' added string ')

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    just got around to this again and want to thank you for your post. worked perfectly!

Posting Permissions

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