Re: Non-case sensitive queries

orrom@itnet.demon.co.uk (Howard Orrom) writes: >My programming colleagues ( Informix fans ) asked if I could put out a call >for advice / help. >In a character column, text can be entered in upper or lower case - >eg. John Smith, JOHN SMITH or jOHN sMITH. >Now, if a search is done for J Smith, how do you ensure that all of the >examples above are returned ? >( Our solution is to have a separate column into which a standardised form >of the text is placed, leaving the 'users' column for use in printed >reports etc) If speed is important and disk space is available, I think yours is a good solution. If the reverse is true, I wrote a 4gl function that would convert your query to: MATCHES "[Jj][Oo][Hh][Nn] [Ss][Mm][Ii][Tt][Hh]" which is guaranteed to be slow. If your're interested, let me know and I'll dig it out and post it. >Anyone got any better ideas ? Answers on 20-pound notes please to .... In the USA, that would be a HEAVY note, not an EXPENSIVE one ... ============================================================ Dennis J. Pimple Informix Software Inc Senior Consultant Denver Colorado USA dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025