i have a table with one column storing telephone and mobile numbers for employees.
inumber 00 exits in 90% of the phones but i want to replace them with "(+)"
[code]
create table emp_phone ( emp_no varchar2(12), emp_mobile varchar2(200))
insert into emp_phone (emp_no , emp_mobile) values ('1','00971506312477')
insert into emp_phone (emp_no , emp_mobile) values ('2','0097143968013')
insert into emp_phone (emp_no , emp_mobile) values ('3','+97143968012')
insert into emp_phone (emp_no , emp_mobile) values ('4','0097143968002')
data i require
1 +971506312477
2 +97143968013
3. +97143968012
4 +97143968002
[/code]