Re: Searching addresses

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 17:29:30 GMT
Message-ID: <3C7E68FE.F8161294@ci.seattle.wa.us>

Remove all integers using TRANSLATE then concatenate it together as '%N%Col%P%' though I expect that figuring out how much to SUBSTRing to get the right combination will be harder than you think. I mean why %P% vs. %Pk% could become quite an issue.

Daniel Morgan

spare_brain wrote:

> 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 Thu Feb 28 2002 - 11:29:30 CST