Bala, You can try: Update table Set column_name = substr(column_name,1,instr(column_name,':',1)-1) || '9999999999') Where {anything} Tom ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bala Sent: Thursday, June 28, 2007 5:29 PM To: oracle-l Subject: Oracle SQL help -- Want to update a column of a table with 150,000 rows columns values are like "JOHN THOMPSON:0011442717" Want to change the numeric value after ":" of each row to a 10 digit constant numeric 9999999999 for all 150,000 rows -- Thanks for all ideas and help. -- Bala Rao