Re: Help with SELECT

Posted in 1995

Peter Pilsl — 13 Jun 1995 00:00:00 +0000 — source: Informix-list mailing list archive (1991-1998)

Nils.Myklebust@CCMAIL.telemax.no writes: >> hsasaki@best.com (Harold Sasaki) writes: >> Can someone help me out on how to do a case-insensitive SELECT on a >string? >> Using version 7.1. Thanks in advance. >> >>>>> > >We have added an extra column to the table to do this. Maintenance of that >extra >column is however a significant problem. You may be able to write a triggered >stored procedure to maintain it. Otherwise you will have to include its >maintenance in every program that updates the table. We have had to do this >as >we require more than simply case insensitivity (we do phonetic search). Can you please help me how to do this phonetic search? Thanks, Peter ------------------------------------------------------------------------ Usenet: peter@ghost.phiger.com