DSXchange

Hi Experts,

How to eliminate leading zero's for the integer:

Input Output
0000101-----101
0010023-----10023
0000045-----45


Can anyone help me on this?thanks in advance for your reply!

use Trim function
Trim(cloumnname,'0','L')

It will trim leading zeros

Thanks nani it's working