Could you create another dict item called NAME.UPCASE and put the MCU in that definition?
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Chris Austin Sent: Tuesday, July 26, 2011 9:25 AM To: [email protected] Subject: [U2] CONV MCU on indexed field? We've been using the following command to select a name regardless of how it's capitalized: SELECT CLIENT WITH NAME CONV MCU = "BRUCE]" However, after I indexed the field NAME on the CLIENT table the same command only returns the values that match the case-sensitive. In other words after we indexed the field name it doesn't seem that we can use CONV MCU, is there a work around to this? Thanks, Chris _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
