Page 1 of 1

SQL number format

Posted: Wed Dec 14, 2005 10:46 am
by mjseaden
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