Decimal data type wont work!

microsoft.public.dotnet.framework.adonet

23 Oct 2007 1:21 AM

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????

23 Oct 2007 1:25 AM

Cirene

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

Show quote

"Cirene" <invalid_em***@zzz.com> wrote in message
news:elRYRMRFIHA.4308@TK2MSFTNGP06.phx.gbl...
>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????
>

23 Oct 2007 1:46 AM

Kerry Moorman

Cirene,

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

Kerry Moorman

Show quote

"Cirene" wrote:

> 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????
>
>
>