Re: Searching addresses

There is a SOUNDEX() function in Oracle that is intended for matching words that sound similar but may be spelled differently. For example, Pky, Pkwy, and Parkway will all get the same or very close values. Regardless of what mechanism you use you will probably have to parse the address into at least the four distinct parts you show in your example and deal with each separately. Also, don't forget that you can use wild cards if your users can just type in the first several characters of each parsed part. For example:
  WHERE part2 LIKE 'N%'

        AND part3 LIKE 'COL%' etc

Regards,
js

"spare_brain" <spare_brain_at_yahoo.com> wrote in message news:a5k30u$mtg18_at_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 Sat Mar 02 2002 - 23:53:29 CST