Virtual attribute to upcase the data value. In unidata ecltype u you can do the following:
SELECT filename WITH EVAL "OCONV(NAME_FIELD,'MCU')" = "uppercase value" Or you could create an actual I or V type field, which you could build an index on. -----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 <html> <body> ________________________________ Dave Davis Team Lead, R&D P: 614-875-4910 x108 F: 614-875-4088 E: [email protected] [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. </body> </html> _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
