MS SQL Query

[baray98]

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

DBVersion Table
DBVersion = 3.03

//SQL statement
Select round(DBVersion,2) As "DB Version from DBVersion

//output 

DB Version = 3.029999999999

To copy to clipboard, switch view to plain text mode