Allowable Decimal Value

Can anyone tell me what is the biggest value that can go
into Decimal (9) field in SQL 7.0 table '. I got an error
when inserting '99999999999'.
Thanks for help.Surely a decimal(9) can store up to 9 digits?
e.g. 999999999
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||A decimal column can hold a value with the maximum number of digits that is
defined as it's precision (that's the number between brackets. So decimal(9)
will only hold values with a maximum of 9 digits and not 11 like you try to
insert.
--
Jacco Schalkwijk
SQL Server MVP
"Kirk" <anonymous@.discussions.microsoft.com> wrote in message
news:d48101c3eff2$5cbead30$a101280a@.phx.gbl...
> Can anyone tell me what is the biggest value that can go
> into Decimal (9) field in SQL 7.0 table '. I got an error
> when inserting '99999999999'.
> Thanks for help.|||But it does insert this: 00232575945
>--Original Message--
>Surely a decimal(9) can store up to 9 digits?
>e.g. 999999999
>
>--
>Cheers,
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>|||Sorry. My bet, It ignores the '0' s.
Thanks.
>--Original Message--
>But it does insert this: 00232575945
>
>
>>--Original Message--
>>Surely a decimal(9) can store up to 9 digits?
>>e.g. 999999999
>>
>>--
>>Cheers,
>>James Goodman MCSE, MCDBA
>>http://www.angelfire.com/sports/f1pictures
>>
>>.
>.
>

Allowable Decimal Value

Can anyone tell me what is the biggest value that can go
into Decimal (9) field in SQL 7.0 table '. I got an error
when inserting '99999999999'.
Thanks for help.Surely a decimal(9) can store up to 9 digits?
e.g. 999999999
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||A decimal column can hold a value with the maximum number of digits that is
defined as it's precision (that's the number between brackets. So decimal(9)
will only hold values with a maximum of 9 digits and not 11 like you try to
insert.
Jacco Schalkwijk
SQL Server MVP
"Kirk" <anonymous@.discussions.microsoft.com> wrote in message
news:d48101c3eff2$5cbead30$a101280a@.phx.gbl...
> Can anyone tell me what is the biggest value that can go
> into Decimal (9) field in SQL 7.0 table '. I got an error
> when inserting '99999999999'.
> Thanks for help.|||But it does insert this: 00232575945

>--Original Message--
>Surely a decimal(9) can store up to 9 digits?
>e.g. 999999999
>
>--
>Cheers,
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>|||Sorry. My bet, It ignores the '0' s.
Thanks.

>--Original Message--
>But it does insert this: 00232575945
>
>
>.
>