TRy
update my_table set codlm='22'||substring(codlm,3) where substr(codlm,1,2) = '45'
HTH
Denis
----- Original Message -----
Sent: Tuesday, February 26, 2002 12:13 PM
Subject: [NOVICE] update
I have a table (my_table) with this structure:
codlm varchar(7)
The records are:
45122AD
45122AD
45123AC
440331B
430332C
440222X
I want to change the first 2 letters from 45 to 22 something like this:
22122AD
22122AD
22123AC
440331B
430332C
440222X
I tried:
update my_table set codlm='22'||substring(codlm,2) where codlm like '45'
but the result is:
225
225
225
440331B
430332C
440222X
Where is the mistake?
Thanks!