Oh right! Duh…
On Feb 26, 2014, at 20:54 , Peter Haworth <[email protected]> wrote:
> You don't need another column.
>
> If you don't get an exact match
>
> SELECT soundex(name)=soundex("Wittier Fun Center")
>
> Not sure of performance implications.
>
> Pete
> lcSQL Software
> On Feb 26, 2014 8:12 PM, "Bob Sneidar" <[email protected]> wrote:
>
>> I just did a query on soundex for 3 values: Whittier Fun Center, Whitier
>> Fun Center and Wittier Fun Center. All returned the same result. I think
>> what I will do is create a column populated with the soundex of the
>> customer name as a secondary lookup when I don't get an exact match, then
>> alert the user and ask him if this isn't really what he wanted.
>>
>> Bob
>>
>>
>> On Feb 26, 2014, at 19:38 , Richard Gaskin <[email protected]>
>> wrote:
>>
>>> I'm still missing it - where can one find Devin's Levenstein function?
>>>
>>>
>>> Bob Sneidar:
>>>> Don't know how I missed that, thanks.
>>>>
>>>> On Feb 26, 2014, at 18:50 , Peter Haworth wrote:
>>>>
>>>>>
>>>>> If I remember correctly, Devin has some functions that implement a
>>>>> Levenstein Distance algorithm which will identify potential
>> misspellings of
>>>>> a word
>>>
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> [email protected]
>>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>>
>> _______________________________________________
>> use-livecode mailing list
>> [email protected]
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
> _______________________________________________
> use-livecode mailing list
> [email protected]
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
