How to trim leading 0s

vvasireddy9

Hello

I am having hard time finding code to remove leading zeros. An example of the string is '00001234' and '0012345'. I need to remove leading zeros to show '1234' and '12345' respectively. Any help?

Thanks
VJ

SruthiA

Hi,

  Please check the below solution. 

dbadmin=>select trim(LEADING '0' FROM '00012345');

ltrim

12345
(1 row)

dbadmin=> select trim(LEADING '0' FROM '0000001234');

ltrim

1234
(1 row)

vvasireddy9

that worked, thank you very much