NewEra Case-Insensitive Search

Posted in 1997

mcampbell@ci.englewood.co.us — 26 Feb 1997 12:33:09 -0500 — source: Informix-list mailing list archive (1991-1998)

I have a data entry field for free form text, allowing the user to enter both upper and lower case text. Is there a way to do a case-insensitive search on this field? i.e.: query "City" and find occurrences of "CITY". Thanks for your help. Michael Campbell City of Englewood, CO mcampbell@ci.englewood.co.us