Converting Single To String - Weird!

[hunt n peck]

Could anyone please shed a little light on how VB converts from Single to
string?

This is what it gives:

SINGLE STRING
4583.3335 "4583.333"
2500.00 "2500"
8750.001 8750.001
18333.332 18333.33
It is screwing up my SQL queries because it seems to randomly choose to
round and change my numbers. Any advice?

Paul

[FM]

Try 'Format' insteand
saludos
Francisco

"hunt n peck" <x> wrote in message
news:ur**************@TK2MSFTNGP11.phx.gbl...

Could anyone please shed a little light on how VB converts from Single to
string?

This is what it gives:

SINGLE STRING
4583.3335 "4583.333"
2500.00 "2500"
8750.001 8750.001
18333.332 18333.33
It is screwing up my SQL queries because it seems to randomly choose to
round and change my numbers. Any advice?

Paul

[Justin Weinberg]

Or try the more robust Decimal data type if your process can stomach the
overhead.

--
Justin Weinberg

Designing a PrintDocument or creating .NET graphics?
Save time with GDI+ Architect.
For more information, visit http://www.mrgsoft.com

"FM" <f.******@verizon.net> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Try 'Format' insteand
saludos
Francisco

"hunt n peck" <x> wrote in message
news:ur**************@TK2MSFTNGP11.phx.gbl...

Could anyone please shed a little light on how VB converts from Single to string?

This is what it gives:

SINGLE STRING
4583.3335 "4583.333"
2500.00 "2500"
8750.001 8750.001
18333.332 18333.33
It is screwing up my SQL queries because it seems to randomly choose to
round and change my numbers. Any advice?

Paul