RE: EVAL and LIKE

2004-02-05 Thread Kevin Michaelsen
I tried it. It didn't seem to work but maybe I didn't do it right. I did include the [1] in there. I'm a newbie, was I not suppose to. I'm also running this in a UNIQUERY statement at the colon prompt. Would that have anything to do with it not running properly. Thanks for whatever light you can

RE: EVAL and LIKE

2004-02-05 Thread Shawn Waldie
Title: Message If all you need is justa count of records in a file with a particular field containing the value "*" or "Incomplete": COUNT file WITH field = '*' 'Incomplete' -Original Message-From: Kevin Michaelsen [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004

RE: EVAL and LIKE

2004-02-05 Thread Harold . Oaks
Title: Message Kevin: A problem is the use of the double-quote more than once - this will fail. Also, in your original below you have the following clause using LIKE: LIKE "'...*' which will not work in the way you want. Because the ...* is within the single quotes, the LIKE statement