Dave, Wyatt & Karen, Thank you so much for the tips! Works like a charm!
Thanks again, Greg At 12:45 PM 5/30/2007, Dave Davis wrote:
In ECLTYPE u SELECT HRPER WITH EVAL "OCONV(HRP.LAST.NAME,'MCU')" LIKE "SC..." If you are currently in ECLTYPE p, you can put the word "SELECT" in lowercase to evaluate using the "u" parser. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, May 30, 2007 1:28 PM To: u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/