I would like to update a column in a table with a string. Later on I would like to add to that string.
I tried the following query,
"update TABLE1 set COLUMN1 = COLUMN1 + 'TEST STRING' where ID = 100"
I get this error, "Invalid operator for data type. Operator equals add, type equals text."
The 'COLUMN1' is of type text.
Any help is appreciated.