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
