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