Skip to Content
0
Sep 20, 2007 at 05:04 PM

Delete some of the leading zeros

11 Views

Hi All,

Just wondering how I can delete some of the leading zeros, but keep two of them.

My field incoming will be '0000000003'. I want to use DELETE LEADING '0', but I want my output to be '003'.

This field incoming can also contain text instead of a number, so I don't want to mess around with field lengths.

Any suggestions?

Thanks

Charla