CONCATENATION

[aspiringprog]

Hi all,

I need to update a table such that the existing values in the column are still there and the new values are concatenated.

I tried using the concat function but it is not accepting the column name as a value

column_name = concat(column_name,'1')

This gives an error saying column_name is invalid identifier.

Any help is appreciated.

Thanks,

 

[lewisp]

Try [tt]column_name = column_name || '1';[/tt]