Have the street number in a field, separate from Street name.
Alternatively, in a query sorting a street number street name field in a duplicate column, use the in str function to strip off the street number leaving the street name to be sorted. This of course assumes that the Strret Number will be numeric only, which I doubt will be the case. Some addresses don't have numbers and some are P.O. Boxes.
You could build a function to do your stripping if it gets too complicated becayse of number types or the lack thereof.
It seems to me that one would want to sort on street name after street number.
