Inserting 100.0 in float column gives 100. Why?

[QuarkSE]

Hi!

I've been trying to insert posts with floats using .0 as decimals, but SQL Server never saves the .0
How do I change this so when I insert 100.0 the post in my db will show 100.0 and not 100 as it does right now.

I've tried using float, decimal and money as types, but none of them work.

Any ideas?

 

[moonshadow]

SQL Server does know about the zero, but you have to format the output from your select statement before displaying it to the user - this is a problem for your front end program, not SQL Server.