Hi,

I have a table in which there is a field for mobile no. Currently the data in the field has been entered with a dash(-) after the code.

eg-

MobileNo (this is the field name)
-------------------------------------
1. 6016-2880537
2. 6012-3137200

so there is about 400 records in the table now. How possible is it for me to replace the delimeter (-) with '' or to remove the dash from the column mobileno with a single query. I know i can go remove the dash manually in enterprise manager,but it's time consuming.

Pls help..any help is greatly appreciated.

Thanks in advanced.