Re: Numeric sorting of addresses

From: KiwiBrian (briantoz_at_ihug.co.nz)
Date: 10/11/04 

Date: Tue, 12 Oct 2004 08:51:31 +1300

"Don Guillett" wrote

> The street will not be ignored unless in a separate column
> 1 aa
> 1234 ff
> 567 dd
> 89 jj

> "KiwiBrian" wrote

>> How do I sort on a column of addresses so that e.g.:-
>> 1234 567 89 1
>> Would be sorted as:-
>> 1 89 567 1234
>>
>> Each entry has the street name following the numeric but these can be
>> ignored in the sorting criteria.

Hi Don.
I thank you for your reply but it was a bit too cryptic for me.
Can you enlarge on what you are illustrating please?

In my specific situation, as I have already successfully extracted all
entries for a particular street from the main database, the alpha text in
each case is identical, and only the numeric portion is different.
So I have the first entry as 1 Foo St and the second entry is 1007 Foo St
and many more entries before coming to 2 Foo St.
I hope this clarifies my situation and problem.

Thanks
Brian Tozer