Re: <No Subject Supplied>

Dear Mr. Kickel: Thanks for your email! I think your method works, if you have the knowledge of the exact word to be matched in advance, such as "VISTA" or "vista". However, what if the input word to be matched is unknown or undefinite? That's why I'm looking for a function that can automatically do the case convertion or something similar. Thanks, Allen :) Email: agu@ai.org } Allen, } } I wouldn't call it a trick but the following expression would be } case insensitive: } } MATCHES "[Vv][Ii][Ss][Tt][Aa]" } } I believe Dennis Pimple even posted a function once that would take a } passed in parameter and create a case insensitive search string for } it. } } On Tue, 9 Apr 1996 16:22:12 -0500, agu@ai.org (Allen Gu) wrote: } } >>From my understanding, Informix SQL keyword "MATCHES" is case sensitive. Th at is, you can use "ISTA" to match "ISTA" or "VISTA", but not "Ista" not "ista" . } > } >However, is there a trick in SQL to make "MATCHES" work for even fields comp osed of characters of different cases?