SEARCH
Sign up to our Newsletter No Spam Guaranteed
If you want to remove leading zero's or any other character from a string, or really do the SQL opposite of LPAD then use LTRIM.
SELECT ltrim(text_string,'0') FROM <tablename>
Free Oracle Magazine