At 2009-07-20 16:43 -0400 Steve Roethel wrote:
all have the same street_name with the same value (no missing or added characters/spaces.
Steve - either the numbers or the street names must have some funnies hidden away somewhere. I have chased this sort of thing around for ags with data that I KNEW was in good order, only to find in the end that there was (eg) a carriage-return at the end of one field. I often find that if I can't see the problem I've been looking in the wrong place!
I suggest you try doing an export of just these few records that you are using as an example, exporting ONLY the fields that you are sorting on (should be just street name & number) but including any others if there are others in the sort order, to a tab-text file.
Then open the file in TextWrangler or similar text editor with fixed-width font and choose the "show invisibles" option.
I'd be very surprised if that doesn't show some clue to the sorting oddity, such as characters not lining up across all lines, or unsuspected hidden characters in one or two records. If the data entry has been done by humans, that sort of finger trouble is all too common.
regards Rowland -- | Rowland Carson http://home.clara.net/rowil/ | <[email protected]> ... that's Rowland with a 'w' ...
