The correct syntax would be this:Update my_table
set my_Col = my_col + 'new text'
where id = 123
It has no "SELECT", so there is no roundtrip.
If there is nothing in my_col (i.e., if it is null), for it to work correctly, you also need to do one more thing, see below:Update my_table
set my_Col = COALESCE(my_col,'') + 'new text'
where id = 123
Append new text to a column
Posted - 10/02/2012 : 11:04:42
