How to trim leading 0s

vvasireddy9vvasireddy9 Registered User

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

Answers

  • SruthiASruthiA Employee, Registered User, VerticaExpert

    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)

  • vvasireddy9vvasireddy9 Registered User

    that worked, thank you very much

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file