I have data in a table with primary key value . The primary key value has prefix with zero's. Example:1 0000000001 0000000002 0000000003 ... ..... 0000000010 0000000011 .... ... .... 0000000099 0000000100 ---- --- 0000000999 0000001000 0000001001 My requirment is to manuall modify the data by SQL Queries in all tables is to remove the prefix ZERO's. At present When inserting a new record for this primary key they are retriving the last value removing the prifx zeros and adding a value to that and inserting a new record with prefix's again manually For new record i will try to modify in java but for existing records in PRDOUCTION DATA Could you please suggest me to remove the prefix as.. Example:1 1 2 3 ... ..... 10 11 .... ... .... 99 100 ---- --- 999 1000 1001
