We are using Unidata and this is a dict for Country: CNTRY:
D 4 MCU Cntry 6L M You could do the same change to the NAME definition but I was suggesting that if you didn't want to or couldn't do that then another definition could be created that forced the name to be upper-case. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Chris Austin Sent: Tuesday, July 26, 2011 9:36 AM To: [email protected] Subject: Re: [U2] CONV MCU on indexed field? I'm not exactly following you. Would this dict item called NAME.UPCASE, would that be a new field to test this or woudl that be a specific field used to do the conversion? What would the dictionary look like. Chris > From: [email protected] > To: [email protected] > Date: Tue, 26 Jul 2011 09:32:48 -0700 > Subject: Re: [U2] CONV MCU on indexed field? > > 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 _______________________________________________ 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
