Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
LOAD
"id",
"id2";
SQL SELECT
"id",
CAST("id" AS varchar) as "id2"
FROM "Base";
Thank you very much, this is the only solution that works for me!