DATA TYPES

> Which data type is most suitable for serial numbers that you expect to > hit 100,000 and more in the course of at least 2 years. Integer is > definately out for a column data type since it will max out and roll > over at about 37600 something. You will get some interesting queries > there! :-) Any suggestions? "A little learning is a dangerous thing..." The integer data type is a whole number from -2,147,483,647 to +2,147,483,647 The serial data type (used for serial numbers) is an integer The smallint is a whole number from -32,767 to +32,767 This all from the OnLine Programmer's Manual, v4.00 page 112 __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|