Re: <No Subject Supplied>

>Dear Mr. Kickel: Sheesh, no need to be so formal Mr. Gu. > >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. > As I mentioned in my last message, Dennis Pimple has written just such a function. It takes a string entered at run-time (e.g., "vista") and creates a case insensitve search string (e.g., "[Vv][Ii][Ss][Tt][Aa]"). You can find this function on the Informix Usergroup Web page (www.iiug.org). Its name is "noncaseqry". The easiest way to find it is to search the archive for the word "brutal". (Really! :) --Mr. Kickel ====================================================================== Craig Kickel | Unix/C/Database Consultant ckickel@cyberhighway.net | <This space intentionally left blank> ======================================================================