I haven't been following this thread very intensely. However, a case insensitive pattern match is straightforward in UniVerse by specifying an on-the-fly conversion to upper case or lower case. As normal there are several ways to accomplish this. I will constrain examples to UniVerse SQL, but remember that the same techniques are available in UniVerse's other query language (RetrieVe). SELECT NAME FROM PEOPLE WHERE NAME CONV 'MCU' LIKE 'SARA%'; SELECT NAME FROM PEOPLE WHERE EVAL "UPCASE(NAME)" LIKE 'SARA%'; SELECT NAME FROM PEOPLE WHERE EVAL "OCONV(NAME,'MCU')" LIKE 'SARA%';
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users