Hi Charles,
Here is what I use, as well as an I-descriptor to do the same thing. You
could build an index on either, depending on your platform.
NAME.MCU
001 S
002 2
003Name Upcased
004
005
006
007
008 MCU
009 T
010 40
011
012 Item name upcased
001 I Item name upcased
002 OCONV(@RECORD<2>, 'MCU') or UPCASE(@RECORD<2>)
003
004 Name Upcased
005 40T
006 S
Charlie Noah
Charles W. Noah Associates
[email protected]
The views and opinions expressed herein are my own (Charlie Noah) and do
not necessarily reflect the views, positions or policies of any of my
former, current or future employers, employees, clients, friends,
enemies or anyone else who might take exception to them.
On 12-03-2010 9:37 AM, [email protected] wrote:
I need to SELECT on a name field that has mixed case and has never been
enforced. John Smith might be entered as John Smith, JOHN SMITH, John,
etc. I can UPCASE the user supplied search argument and do a partial
string match, but I am not sure how to handle the SELECT.
Is there an option in a SELECT to ignore case? Or alternatively, if I
make a virtual attribute to upcase the data value, what is the best way?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
_______________________________________________
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
