Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I supress zeros in an char field?
Example: customer number = 00003212
I want let it as '3312' direct in the script
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.
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.
hi Robson,
You can use Num function
num(Customer number)
Convert using the Num function.