About FLOAT fields and 8+ digit numbers

[Guest_imported]

I have a simple table that has FLOAT numbers between 1 and a few billion. I use ASP to write a simple select * from SQL and display the results in a table. However, when I display the default info, anything larger than 7 digits reverts to scientific notation. So far, I have been unable to stop this sillyness. Using a standard ADO Conn, and MySQL ver 3.22.

I would like to show these as normal numbers, perhaps with commas, without having to mess with strings.

Thanks for any help in this matter.