RE: EVAL and LIKE

[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 shed on my case.

kevin

At 11:24 AM 2/5/2004 -0500, you wrote:

Perhaps this will help:
 
EVAL "IF (FIELD.NAME[1] = "*" OR INDEX(FIELD.NAME,'Incomplete',1)) THEN 1 ELSE 0"

-----Original Message-----

From: Kevin Michaelsen [mailto:[EMAIL PROTECTED]]

Sent: Thursday, February 05, 2004 11:14 AM

To: [EMAIL PROTECTED]

Subject: EVAL and LIKE

I'm trying to get this statement to work:

Basically I'm trying to count the number of records that have a FIELD.NAME that has an "*" or an "Incomplete".

TOTAL EVAL "IF(WITH FIELD.NAME LIKE "'...*','Incomplete'") THEN COUNTER ELSE 0"

Thanks for any assistance.

Kevin

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users