It appears you cannot use IN (...) in a WHERE statement with EDIT:

TABLE FILE CAR
PRINT
CAR MODEL COUNTRY
WHERE EDIT(COUNTRY,'99$') IN ('EN')
END

Anyone find it odd that this cannot be done?

I'm sure SQL can handle this.

Francis,

It says in the book:

(FOC774) THE WORD 'IN' MUST APPEAR IN A VALID CLAUSE
The following clauses must adhere strictly to the specified syntax:
'field IN FILE filename' and 'field IN (x,y,z)'.

But you could do this...

DEFINE FILE CAR
CNTRABBR/A2 = EDIT(COUNTRY,'99$');
END

TABLE FILE CAR
PRINT
CAR MODEL COUNTRY
WHERE CNTRABBR IN ('EN')
END

Thanks both.

quote:

WHERE EDIT(COUNTRY,'99$') IN ('EN')

or you can say
WHERE EDIT(COUNTRY,'99') EQ ('EN');