SQL number format
Posted: Wed Dec 14, 2005 10:46 am
Hi,
I'm using ADO to call an SQL query on a CSV file. I'm not sure what 'type' of SQL ADO uses, but I'm asking here because from past experience with PHP/MySQL, people here know what they're talking about.
I am extracting a long number, 19 digits long, and the field I get out is in 'scientific' number format, e.g. 1.23456E+17. I want the number straight, which means it might be better to extract it as a string rather than as a number. Is this possible?
Many thanks
Mark
I'm using ADO to call an SQL query on a CSV file. I'm not sure what 'type' of SQL ADO uses, but I'm asking here because from past experience with PHP/MySQL, people here know what they're talking about.
I am extracting a long number, 19 digits long, and the field I get out is in 'scientific' number format, e.g. 1.23456E+17. I want the number straight, which means it might be better to extract it as a string rather than as a number. Is this possible?
Many thanks
Mark