Re: Sounds like searching

Chris Have a look at http://www.informix.com/informix/grants/sharewarecoop/bladelets/soundex_dat ablade.htm. This gives details of how to create a soundex datablade. HTH Davin 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 ******************************************************************** Any opinions, express or implied, presented are solely those of the author and do not necessarily represent those of Standard Chartered Group ********************************************************************