Hey Chad: Yes all have the same street_name with the same value (no missing or added characters/spaces.
On 7/20/09 4:16 PM, "Chad Novotny" <[email protected]> wrote: > Your sampling of street_numbers... do all five have the same street_name? > Because otherwise you would not expect to see the second field in the sort > order have any affect. > > Regards, > Chad > > *************** > Chad Novotny > Vice President - Technology > The Support Group, Inc. > database design, development and training services > boston - los angeles - new york - san francisco > > 24 Prime Park Way > Natick, MA 01760 > t: 508.653.8400 x217 > f: 508.653.2830 > [email protected] > www.supportgroup.com <http://www.supportgroup.com> > > > On Jul 20, 2009, at 4:07 PM, Steve Roethel wrote: > >> Happy 40th Moon Landing Day! >> >> Perhaps I¹m doing something wrong with a simple sort to obtain a typical >> list of two common address fields. >> >> Sort Order: >> >> street_name (text) >> street_number (numeric) >> >> Results... The street_name appears to fall in ascending order, however, a >> sample of ascending street_number falls like this: >> >> 3199 >> 3223 >> 3233 >> 2590 >> 3101 >> >> I¹ve get the same results whether the street_number is text or numeric with >> the same data. I ruled out extra characters and spaces. >> >> Suggestions? >> >> Thanks, >> Steve >> >> FM10 Adv OS 10.4.11 >> FMS 8 OS Server 2003 >> > > > > > >
