Re: Like operator in a query
On 16 Aug, 15:06, "ssailer" <[email protected]> wrote:
> I ac tually got this to work preivously with an app. I built for calculating
> distances and finding locations, but it was a mess. I had to connect the
> to a master lookup table, which included every possible spelling combination
> for an abbreviated city. I was really hoping there might be an easier way
> because it was a total pain to get it working!
You are trying to persuade the computer to recognise that
St.=Sant=Saint? - common (mis)spellings. You will have to have some
kind of lookup...