smallints

Hi all, I know that a smallint can only store values in the range -32767 to +32767. However is there any way to force the value to be unsigned and therefore store up to 65534. Regards, Karen

Karen No, you have to use integer (int) if you want to go that high Keith -> -----Original Message----- -> From: Egan Karen-.... [mailto:Karen.Egan@motorola.com] -> Sent: Friday, June 13, 2003 2:09 PM -> To: ids@iiug.org -> Subject: smallints [1356] -> -> -> Hi all, -> -> I know that a smallint can only store values in the range -> -32767 to +32767. However is there any way to force the -> value to be unsigned and therefore store up to 65534. -> -> Regards, -> Karen -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **