Build an I descriptor with an MCU conversion:
>ED DICT BP UCNAME
New record.
----: I
0001= I
0002= NAME.FIELDNAME
0003= MCU
0004= Name
0005= 35L
0006= S
0007=
Bottom at line 6.
----: FI
[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
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
