handling Bigint as char datatype-DecimalToString conversion

ray.wurlod · Post by **ray.wurlod** » Thu Nov 06, 2008 12:15 pm

The output data type needs to be string of some kind. You can not prepend zeroes to a numeric data type - they are stored internally in binary format.

dsedi · Post by **dsedi** » Thu Nov 06, 2008 12:56 pm

ray.wurlod wrote:The output data type needs to be string of some kind. You can not prepend zeroes to a numeric data type - they are stored internally in binary format. ...

Thanks Ray!

We were having the output data type as Char
and i saw your lines on the other thread

ray.wurlod wrote:prepend zeroes to a numeric data type - they are stored internally in binary format. ...

so we were doing DecimalToString as i have explained in my original post and it was not working.(we were getting only 0's as the output from
DecimalToString(Inlink.column,"fix_zero")
irrespective of the values in the Inlink.column.
)

ray.wurlod · Post by **ray.wurlod** » Thu Nov 06, 2008 4:45 pm

OK, then try something like

Code: Select all

Right("00000" : DecimalToString(InLink.MyField, fix_zero), 5)