baray98
14th July 2009, 04:25
I want to trim my data to two decimal places and I must do it on my SQL statement. I am not successful with the statement below.. please help
It need to work on MS SQL and Access.....
DBVersion Table
DBVersion = 3.03
//SQL statement
Select round(DBVersion,2) As "DB Version from DBVersion
//output
DB Version = 3.029999999999
It need to work on MS SQL and Access.....
DBVersion Table
DBVersion = 3.03
//SQL statement
Select round(DBVersion,2) As "DB Version from DBVersion
//output
DB Version = 3.029999999999