RE: unibasic select woes
Thank you. The “‘word’…” format is the answer to a question that had
me banging my head yesterday.
David Morelli, UIS/Datatel Team
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
Dave, Wyatt & Karen,
Thank you so much for the tips!
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.
>From: [hidden email]
>[mailto:[hidden email]] On Behalf Of Greg Schraiber
>Sent: Wednesday, May 30, 2007 1:28 PM
>To: [hidden email]
>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!