I want to listed data in two decimal places

February 22, 2012 at 04:16:10
Specs: Windows XP
I work with MySQL Database and VB6
SELECT format(Prevtaksi,2)
FROM tov_adm
Where Prevtaksi is not null

the result is like 2,345.88 and this is char
and when convert to number the result is 2

Please help me


See More: I want to listed data in two decimal places

Report •

#1
February 22, 2012 at 06:22:39
I'm not sure of the question. If you want it as a number, keep it as a number. Don't convert it to a string, and then back into a number. If you want it to be a string, don't convert it back to a number.

How To Ask Questions The Smart Way


Report •
Related Solutions


Ask Question