My sql statement is selecting a list of addresses how can i make it ignore the house number and order it alphabetically when the house number comes first when data is entered(ie 15 This Street)?

almost forgot, the sql statement i'm using now is
Code:
Select Address From Property Order By Address
[Edited by PJB on 10-16-2000 at 02:27 PM]