Re: Case sensitive ?? How to turn off ??

> Johan Andersson <Per.Lundkvist@Noventus.se> writes: > Hello. > > Got problem finding information how to turn off case sensitivity. > > Informix-SE 7.1 There is no direct support for this in any Informix database. (Many have asked for it. Are you listening Informix?). Some have said it may be possible to write a stored procedure that does this, but I haven't seen any function in the stored procedure language of Informix that can do this. (Anyone who have done it?) An alternative is to create an extra column in the database that contains the upshifted (or downshifted) version of the data you want to search for, and use this for the search. Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My opinions are those of my company