supress zeros

[rcandeo]

How can I supress zeros in an char field?

Example: customer number = 00003212

I want let it as '3312' direct in the script

[Miguel_Angel_Baeyens · Accepted solution]

Hello Robson,

The fastest way is converting it to a number with Num(Field) which will represent the value as as integer in this case.

Num(CustomerNumber) AS CustomerNumber,

Hope that helps.

[deepakk]

hi Robson,

You can use Num function

num(Customer number)

[#4]

Convert using the Num function.