In some controls (in VB6) when I display the outcome from my Select statement, I get:
I solved the problem of displaying zeros by:
Select SomeField * 1 as MyField From ...
And I get:
(I'm sure there is a better way to do it...?)
But now, what do I need to do (in my Select statement) to get 0.5 (zero point five) - instead of .5 (point five)?