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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 26, 2011 9:36 AM
To: u2-users@listserver.u2ug.org
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: bl...@shaklee.com
> To: u2-users@listserver.u2ug.org
> 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: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris 
> Austin
> Sent: Tuesday, July 26, 2011 9:25 AM
> To: u2-users@listserver.u2ug.org
> 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
> U2-Users@listserver.u2ug.org 
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org 
> http://listserver.u2ug.org/mailman/listinfo/u2-users
                                          
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to