Re: Non-case sensitive queries

Posted in 1994

Bruce Momjian — Wed, 20 Apr 1994 23:56:21 GMT — source: Informix-list mailing list archive (1991-1998)

Howard Orrom (orrom@itnet.demon.co.uk) wrote: : In a character column, text can be entered in upper or lower case - : eg. John Smith, JOHN SMITH or jOHN sMITH. The best way I know to do this under Ingres SQL is to create a view that uppercases the fields you are interested in. However, as Informix does not have an uppercase() operator IN SQL, I don't think this applies, but someone else may know a way of implementing this in Informix. -- Bruce Momjian | 830 Blythe Avenue root%candle.uucp@bts.com | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)