Float to 2 decimal positions

[matt23lucier]

I have a column named 'Amount' that is of type float. I would like to in a select statement display this column with only 2 decimal positions. Does anyone know how to do this? I thank you in advance for your help.
Matt

 

[Qmoto]

Try this...

CAST(AmountField AS DECIMAL(10,2)) AS AMOUNT
 or
CAST(AmountField AS NUMERIC(10,2)) AS AMOUNT

I think that should do what you're looking for. Just change the (10,2) to whatever precision you need.

Cheers!