update tricks

[reeshe]

Hi Friends,

Oracle 9i DB

I have table EMP with column EMPNO (varchar2(10))
with values:

EMPNO
---------
FL-1000
FL-1001
FL2000
FL2001

How do I update the column to remove 'FL' and 'FL-'

I can not do it this way
update emp set empno=substr(empno,4,4) where empno like 'FL-%';
update emp set empno=substr(empno,3,4) where empno like 'FL%';

Can you please give a better way

Thanks a lot

[akas_chauhan]

Find substr(empno,1,3). If it's FL- then you can fire update emp set empno=substr(empno,4,4) where empno like 'FL-%'; and if it's FL1,2 what ever fire your second update. Do it using pl/sql

[davey23uk]

my god no - use the replace functiomn (what its there for)