Re: Non-case sensitive queries

}Date: Thu, 21 Apr 1994 09:34:06 -0600 (MDT) }From: Con Woodall <cwoodall@vth1.vth.colostate.edu> }Subject: Re: Non-case sensitive queries }To: Joseph P DeCello III <discovery!decello> }X-Informix-List-Id: <list.3840> } }On 20 Apr 1994, Joseph P DeCello III wrote: }> What if I enter "Joseph P DeCello III", your program would change it to: }> Joseph P Decello Iii }> }> this is undesirable. } }There is a fairly fixed set of exceptions that can be programmed around }in editing (e.g. II, III, and even IV) for datat to be retained and you }probably have no need to edit the query which will want to match anyway. The complaint was more about "Decello" for "DeCello". Roman numerals can be handled. Then there are the Dutch with van Xyz, and similar problems with Germany (von). I'm not sure how you code around my friend Mr Don Macdonald from Ireland, and any Mr MacDonald you care to name from Scotland:-) Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>