If you need one on the fly try: SELECT filename WITH NAME_FIELD CONV "MCU" = "uppercase value"
CONV is a valid function on the command line. As an aside, FMT is also valid, so you can change the format on the SELECT, LIST, or SORT commands lines. Tom RATEX Business Solutions -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, December 03, 2010 10:38 AM To: [email protected] Subject: [U2] Uppercasing in SELECT 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
