Searching addresses

From: spare_brain <spare_brain_at_yahoo.com>
Date: Wed, 27 Feb 2002 21:25:09 -0500
Message-ID: <a5k30u$mtg18@kcweb01.netnews.att.com>

Folks,

I am trying to find examples of SQL snippets that shows an address search as follows. Such searches are very common in map searching.

For example, the "Address_Line" attribute has entries of the form

100 N. Columbia Pky
100 N. Columbia Parkway
100 North Columbia Pky
100 North Columbia Parkway
222 North Columbia Pky

Now, my search query should be such that when the user enters "N Col Pky", it should fetch all of these entries.

Could someone provide some pointers, and/or other leads into finding similar examples?

Any help would be great and save a SQLed soul.....so Thanks!

sb

---

"..Life is like a database query, you never know what'cha gonna get.." Received on Wed Feb 27 2002 - 20:25:09 CST