Re: Is this really NOT a feature of Informix????

>>> The problem is that Informix does not seem to have the ignore case feature? >>> IMHO, this is a very important feature that should come as a basic package agreed. >>> Does anyone have a solution to my problem of joining these two fields. one solution is to use temp tables and the 4gl to handle the conversion. another is below. >>> Altering the original data is out of the question as the lists are hundred >>> and/or thousands of records long. not necessarily. you could unload to a text file, run that through a case conversion tool (unix), then reload and delete the offending data.