My best way
UNIDATA:
SELECT PERSON WITH SORT.NAME LIKE '...SMITH...JOHN...' '...JOHN...'
SORT.NAME: TRIM(UPCASE(((LAST.NAME:FIRST.NAME):MIDDLE.NAME)))
OR
xResult1 = ((vLastName : vFirstName :
vMiddleName)).ToUppercase().Trim();
return (string)xResult1;
-----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
