Link to home
Start Free TrialLog in
Avatar of thenrich
thenrich

asked on

Round decimal

I'me trying to return a dataset in which a field in the dataset is 3 decimal places due to the datatype of the field. I would like to return a rounded two decimal value in the data set.

3.256 would be 3.26
Avatar of rushShah
rushShah
Flag of India image

you can use round function..

try this...

select round(3.256,2)
ASKER CERTIFIED SOLUTION
Avatar of rushShah
rushShah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thenrich
thenrich

ASKER

My dataset still shows 3 decimals
that did it.