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
SQL number format
Moderator: General Moderators