Create a new dictionary item like the following: ED DICT HRPER UPC.HRP.LAST.NAME 001: V 002: OCONV(HRP.LAST.NAME, "MCU") 003: 004: 005: 10L 006: S
SELECT HRPER WITH UPC.HRP.LAST.NAME LIKE 'SC...' Bruce W. McAdoo Wagner & Brown, Ltd. [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, May 30, 2007 12:28 PM To: [email protected] Subject: [U2] unibasic select woes How does one select alpha-numeric data from a unidata datafile using SELECT when the case of the text is not known? I have tried things like: SELECT HRPER WITH UPCASE(HRP.LAST.NAME) LIKE 'SC...' but all I get is a syntax error. Can someone tell me which function(s) can be used to facilitate this type of search? Any help is greatly appreciated! Thank you, Greg ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
