Re: Searching addresses

tip:
1) BUY some good software which is U.S. Postal Service certified (CASS). 2) Standardize all addresses using this software prior to insertion into the database

    for example, the human eye can see that your 100 N COLUMBIA PKWY     addresses are really all the same logical address, so you shouldn't have four records

There are way too many variations on the way people submit their addresses, particularly with PO Box and PMBs
Not all addresses are valid / complete -- good software can correct some of this for you.

"spare_brain" <spare_brain_at_yahoo.com> wrote in message news:a5k366$mtg19_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 Tue Mar 05 2002 - 22:00:17 CET