Percentage field with 4 decimal

[AppDev76]

Hi,
I have a percentage field in one of my tables. I set the data type to float, I wan't 4 decimal places and the data in the table has 4 decimals, but when I run a query in query analyzer it returns: 4.4999999999999998E-2 instead of 0.045.
How can I fix this?

 

[SQLSister]

Float is not an exact datatype, you should convert it to decimal in your query or in your table if you can.

Questions about posting. See faq183-874

 

[AppDev76]

Thanks