Need quick help. I know it may be easy, but can't find out how to do it.

I want to add text to a specific column in a specific table. I want the text to be added to the end of the current data for each row in that column for that table.

Ex: I want to add 'J Fontestad' to the end of every row in the column 'from' and table 'gone'.

How would I do that? What would be the SQL command?

Thanks.

 

Try a subselect if your database supports it. Something like

Update Table1 set AColumn ( (Select AColumn from Table1) || 'J Fontestad' )

 

That didn't work. I received an error on line 1.

I substituted table1 and acolumn for my own of course and it didn't work. Any other suggestions ?

 

UPDATE gone SET from = CONCAT(from, ' J Fontestad');

 

That did the job.

Thanks.