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

instead of '||', try,

CONCAT(columnName, ' added string ')

just got around to this again and want to thank you for your post. worked perfectly!