Remove leading Zeros in field

Tools & Utilities
Enthusiast

Remove leading Zeros in field

Hello everyone,
I need to remove leading Zeros from a client file… what is the quickest method?

00073652 should read 73652
2 REPLIES
Enthusiast

Re: Remove leading Zeros in field

Cast to numeric (decimal, integer ?)
and re-cast to char if necessary.
Enthusiast

Re: Remove leading Zeros in field

Folks I found the answer thank you for your viewing.
the Trim function did the trick...

Select
src_appl_acct_no,
trim (LEADING '0' FROM src_appl_acct_no)
From symmktg.vsym_cust_acct
sample 10