converting scientific notation 1.30508E+11 to a text

[shree909]

Hi ,

I am having issue in converting the (1.30508E+11) into a number.

i tried using the  number format in the list box still this is not changing.

could someone look into this?

Thanks

[SunilChauhan]

Hi ,

You are correct. but it will insert zero only afterword.

there is no way that make it 1.30604E+11 as  130604002402. the

if 130604002402 is somewhere in data and if it show like this 1.30604E+11.then after converstion it will give 130604002402.

but if you ask for  1.30604E+11 to convert into number then it will give 13060400000000......

hope you will understand.

[Vadim_Raschupkin]

LOAD
"id",
"id2";
SQL SELECT
"id",
CAST("id" AS varchar) as "id2"
FROM "Base";

[GioINI]

Thank you very much, this is the only solution that works for me!