Greg, Actually the following in saver:
SELECT HRPER WITH EVAL "OCONV(HRP.LAST.NAME,'MCU')" LIKE "'SC'..." (note the extra ' around the text) there are a few alphanumeric characters that are interpreted by SELECT and it will show you weird results when you are not expecting that. Regards, Andre -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: maandag 30 april 2007 11:12 To: [email protected]; [email protected] Subject: RE: [U2] unibasic select woes 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: [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/ ------- 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/
