[AccessD] Re: Number vs text data type

Drew,

Yeah, it works great until they make it look like Canada's.

Zone Improvement Plan Code (ZIP Code) is a code not a value,
therefor it is alpha-numeric and not a pure numeric.

And, the Plus4 may become the Plus6. ;-)

Robert

At 12:01 PM 10/15/2003 -0500, you wrote:
>From: Drew Wutka <DWUTKA at marlow.com>
>Subject: RE: [AccessD] Number vs text data type
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID:
>         <2F8793082E00D4119A1700B0D0216BF802227335 at main2.marlow.com>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>Ah, but you can always add fields to handle new anomalies!  With the zip
>code, just add an 'extension' field.  Original Number field is left intact
>(and all 'search' routines) would still work.
>
>Drew