number

[johnan]

I, i have a number:

00037350036211221

When a read in this in qv i'll get;

3,7350003625384e+017

What can i do?

[#2]

Hi,

A numeric value can't have preceeding 0. it can be read as string ( use text() function). later on you can convert in number (use num() function).

Thanks & Best Regards,

Kuldeep Tak

[johnan]

Hi, i have in the script

text(myfield) as [mynumber]

But it' wont work

[#4]

HI Johnan,

I believe that your field is too long. Numeric fields can have a length of around 14/15 and yours is longer. We came across this issue recently and our solution was to change the field to text in the source database instead of converting.

What it did in our case was cut of the field after position 14/15 and add 0 (zero's) to fill it up to the length of the original field. Therefore, we have moved around this by changing the source to text.

[#5]

try using number formatting

num(myfield, '000000000000000000')

[johnan · Accepted solution]

Hi all, its solved.
I'ts from DB2 and in the SQL i use DIGITS.