Integer Datatype

[Sanjeev Kumar]

Hi all,

I have a situation where I will have to insert a value(whole number) into the table where the the value is more than what the Integer can hold , I was wondering is there any other datatype which i can use other than integer


Thanks in advance.

Sanjeev Kumar

[MAK]

use decimal with no precision.

create table xxxxxx( xxx decimal(5,0))



-MAK
------------
Sanjeev Kumar at 12/4/00 11:25:09 AM

Hi all,

I have a situation where I will have to insert a value(whole number) into the table where the the value is more than what the Integer can hold , I was wondering is there any other datatype which i can use other than integer


Thanks in advance.

Sanjeev Kumar