Sounds like searching

Posted in 1999

Chris McKay — Fri, 3 Sep 1999 11:21:59 +1000 — source: Informix-list mailing list archive (1991-1998)

Hi, Does anyone know of something that Informix provides (Datablade, some sort of filter) that provides Fuzzy or Soundex searching on a VARCHAR column, i.e. SELECT lastname where lastname LIKE "Mac%" would return "McKay" and "MacKay" I've looked a bit a Excalibur and Verity but these seem like overkill for the simple function that I want. Chris

↪ replying to Chris McKay

Mike Aubury — Fri, 3 Sep 1999 08:08:06 +0000 — source: Informix-list mailing list archive (1991-1998)

Check iiug.org for the soundex stored procedures On Fri, 03 Sep 1999, Chris McKay wrote: >Hi, > >Does anyone know of something that Informix provides (Datablade, some sort >of filter) that provides Fuzzy or Soundex searching on a VARCHAR column, >i.e. SELECT lastname where lastname LIKE "Mac%" would return "McKay" and >"MacKay" I've looked a bit a Excalibur and Verity but these seem like >overkill for the simple function that I want. > >Chris

↪ replying to Mike Aubury

Walt Hultgren — Tue, 07 Sep 1999 14:07:50 -0400 — source: Informix-list mailing list archive (1991-1998)

Mike Aubury wrote: > > Check iiug.org for the soundex stored procedures There are also some routines that implement an alternate sounds-like algorithm called Metaphone. Walt. -- Walt Hultgren Software Repository Manager International Informix Users Group Mailto:software@iiug.org -- HTTP://www.iiug.org/