rounding a number

[katgirl]

Just wondering the best way to round a number as part of select statement.

Right now I am getting numbers like 1.05838784 - I would like to round this to 1.06.

Is there a function to do this... or a datatype I can cast to.

Thanks

 

[Walid]

There is a function and it is called – surprise – ROUND()

SELECT ROUND(1.05838784,2)
will give you what you want


Walid Magd (MCP)

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch

 

[katgirl]

I tried that... I get back 1.060000000 !

Don't want to see all those extra zeroes

 

[Walid]

SELECT STR(ROUND(1.05838784,2),10,2)

Adjust 10 or calculate it using the length of the integral part. Read the help for more info. Good luck

Walid Magd (MCP)

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch

 

[gmmastros]

You could also convert to decimal:

Select Convert(Decimal(18,2), 1.05838784)



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[katgirl]

thanks george