Removing Leading Zeros

Removing Leading Zeros:

Sample data:

SQL> SELECT '0000100' AS Num FROM dual;

NUM
-------
0000100

Option 1:

SQL> SELECT To_Number('0000100') AS Num FROM dual;

       NUM
----------
       100

Option 2:

SQL> SELECT LTrim('0000100','0') AS Num FROM dual;

NUM
---
100

Read More