Update a table with Junk Values 1

[barnard90]

Hi

I have a employee table with Empno and Empname
The Empname has all Employee names like
John Smith,
Robert Jones
Alice Williams
.....etc

However , The names are preceeded by " and the Empnames are looking like

"John Smith
"Robert Jones
"Alice Williams
"Keith Fowler

How do I eliminate the " and get data in a normal way
Can someone please suggest an Update Query for table "EMPLOYEE"

Thanks

 

[Turkbear]

Hi,
Try:

Update EMPLOYEE set EMPNAME = REPLACE(EMPNAME,'"','')

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Beilstwh]

iF YOU WANT TO GET RID OF THE FIRST CHARACTER IF IT IS A " THEN

Update employee
set empname = substr(empname,2)
where substr(empname,1,1) = '#';

If you want to get rid of ANY " then

update employee
set empname = replace(empname,'"');

Bill
Oracle DBA/Developer
New York State, USA

 

[barnard90]

Beilstwh

Thanks a lot for your valuable post
It works