How to remove leading zeros from a string using SQL

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>