2 billion is correct.

Range is(2,147,483,647) to (-2,147,483,647)



Chris Kevins
Software Developer
3E Europe Ltd
01223 421941
ckevins@3...


-----Original Message-----
From: Mike [mailto:mikeos1000@h...]
Sent: 23 September 2002 20:07
To: sql language
Subject: [sql_language] INT/INTERGER data type

Hi,

I have the Beginning SQL Programming book from Wrox (which totally
sucks), and it talks about data types. In one part it suggests the
INT/INTERGER data type has a range from -2 million to +2million, then
later it suggests that it's range is 2 billion. Can someone please tell
me which is correct?

Thanks