Updating Character Fields

[andyhutch]

I have a large database which has been loaded with incorrect data.

I need to alter 1 of the fields which contains 'abc'
and change it to 'nabc'

I tried

update customer
set client_reference = 'N' + client_reference

This did not work as this is how I would treat a numeric field. How do you update a text field to stick a letter at the front?

 

[stefanhei]

Hi.
The operator for cancatenating strings is ||

update customer
set client_reference = 'N' || client_reference

should work.

Stefan