column self-update query question

[jcf27]

I need help in writing a query that will self-update a column.

For example: Column A contains 'ABC.myname'. 'ABC.' is a constant and appears in certain records. How could I easily get rid of it? I tried doing a self-update doing a substring, however, I failed somewhere in the self-join.

Thanks in advance!

J.

 

[swampBoogie]

update t set a = substring(a from 5) where a like 'ABC.%'

The syntax for substring in your DBMS may differ from what is defined in the Core sql 99 specification.