Question on sql commands using fpodbc
Kenneth Brody
kenbrody at gmail.com
Wed Jul 4 18:29:31 PDT 2018
On Mon, Jul 2, 2018 at 6:24 PM, Bruce Easton via Filepro-list
<filepro-list at lists.celestial.com> wrote:
> Someone replied off list to explain to me that the "like" operator in SQL
> matches patterns, so for certain purposes that might be desired. And that
> one would expect output from filepro's fuzzy search to be more like SQL'
> Soundex function since they are evidently both based on Soundex.
I don't know where you got the idea that filePro's fuzzy search was
Soundex-based, but it's not. It's a patented "proximity search"
algorithm licensed by fPTech from a third party. Soundex is a whole
other animal, and is a simple "matches / doesn't match" value.
Wishing everyone a Happy Independence Day. (Even those outside the
U.S. Pop open a beverage and put some meat on the Barbie.)
More information about the Filepro-list
mailing list