This is really annoying I have a money field that SQL Server keeps rounding so if I enter 17.99 it turns it into 18 when I retrive the value from the DB I get 18.000 back. Im relatively new to MSSQL and my beginner book is on the way.....whats the deal?

I've also tried the field as a decimal with the same result.

All right I've found the problem was in my insert stored procedure i had left it as a decimal thats now fixed. Now I need help with the trailing zeroes. They're not stored in the DB is this something I should parse out in my app or that I can fix in my retrieval stored procedure.