Decimal data type wont work!

[Cirene]

I have a SQL Express db with a table field defined as data type
decimal(18,0).

When I type in .785 in the table field it rounds it to 1.

Any ideas why????

 

[Cirene]

Why do I have to use float? Doesnt decimal indicate that you can use a
decimal?

 

[Guest]

Cirene,

Isn't your specification saying that you want 0 digits to the right of the
decimal point?

Kerry Moorman