HI,
I found this WHERE clause in e fex :
WHERE NOT (FIELDA EQ 'A' OR FIELDDB EQ 'Z');
Is it a valid clause ?
I don't find this in any documentation
Thank's

it's valid.

TABLE FILE CAR
SUM SALES
BY COUNTRY
-*WHERE NOT (FIELDA EQ 'A' OR FIELDDB EQ 'Z');
WHERE NOT (COUNTRY EQ 'ENGLAND' OR COUNTRY EQ 'JAPAN');
END

quote:

WHERE NOT (FIELDA EQ 'A' OR FIELDDB EQ 'Z');

Sometimes negative logic works. In this case if it bothers you, I think

WHERE (FIELDA NE 'A') AND (FIELLB NE 'Z');

Would do the same, correct me if I'm wrong guys and gals.