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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
