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!