Microsoft KB Archive/69305

Works: Sorting 9-digit Postal Zip Codes

PSS ID Number: Q69305 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

When sorting five-digit zip codes (for example, 98520) with nine-digit zip codes (for example, 98520-6399), the nine-digit zip codes will not sort properly.

To work around this problem, enter all of the zip code numbers as text strings by inserting a quotation mark at the beginning of each zip code (for example, enter 98052 as &quot;98052).

As text, the five- and nine-digit zip codes will sort properly.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.