Re: functions e.g. UPPER

Andy Wilson (andyw@mountfield.co.uk) wrote: : Are there any plans to include SQL functions, especially UPPER (or LOWER) : in any future or current releases of Informix RDBMS. : We have clients who have been asking for case insensitive searching for : years! : We can do it in Oracle or SQLBase and probably lots of other RDBMSs but : NOT informix Hi There To get case insensitive searching in Informix use UPSHIFT. eg LET fv_name = UPSHIFT(fv_name) This will return fv_name in all upper case letters. I don't know if there is a 'LOWSHIFT or LOWER' version of the UPSHIFT command. I hope this is of some help to you. Let me know if it solves your problem Regards Gary Harvey (Wellington, New Zealand)