Case Insensitive Searching (was Re: functions e.g. UPPER

In article <dewey-1405952049340001@dial53.netmetro.com>, dewey@usa1.com (Devan Dewey) wrote: > In article <3oargo$2f7@cssun.mathcs.emory.edu>, kmart!jregep@uunet.uu.net wrote: > > > uunet!mountfield.co.uk!andyw (Andy Wilson) writes: > > > > >Are there any plans to include SQL functions, especially UPPER (or LOWER) > > >in any future or current releases of Informix RDBMS. > > > > I doubt it very much that Informix will provide the solution you want, they > > tend to leave these things up to the developer. As for case insensitive > > searching try one of the following: [edited out of message] Please re-post or email if other than: 1) QBE: *[aA][bB][cC]* 2) up-case'ing duplicate column. > I have been told that case-insensitive serches will be included in OnLine 8. Not in S/E? ---------------------------------------------------------------- David Baril Bell-Northern Research Ltd baril@bnr.ca HR Systems Group, Ottawa Tel: (613) 765-4572 FAX: (613) 763-4377