Hello! I'm relatively new to the world of databases, and I'm working on VB/ASP pages that execute simple SQL against a FoxPro database to dynamically generate pages. It's a real estate database generated by 3rd party software, and I'd like users to be able to sort results based on street name (not number). However, the address field looks like this:
5838 Waveland Avenue
My understanding is that it should be simple to do this, but I can't seem to find a clear answer anywhere. Any takers?