Monday, March 19, 2012

convert value to 2 decimal places?

Hello, is there a way to convert the value to just 2 decimal places, I created the report in Reporting Services and it has quite a few digits to each value. I looked at the table and found that the data type is {Float}. Is there a way to convert the values to just 2 decimal places?..Thank You.

Try this...

Code Snippet

select cast(columnName as numeric(10,2)) as 'columnName' from tableName

|||That worked, Thank You...

No comments:

Post a Comment