Register
Sign In
The not operator reverses the meaning of any comparison operator it precedes (e.g., STATE not = (equals) " NY" means any state except New York).
Syntax
VALUE 1 not comparison operator VALUE 2
Usage
The not operator's effect can often be accomplished by stating the comparison in a different way. For example, < (less than) can be substituted for not >= (not equal or greater than). Whenever possible, comparisons should be stated as a positive expression.
Examples
means the value in the TOTAL DUE field is less than or equal to 500.
STATE not = "NY" and STATE not = "NJ" ;
means any state except New York or New Jersey.
When you combine two or more comparisons using the not operator, you must use and in the comparison. If you use or in conjunction with not, as shown below, every record in the file is processed.
STATE not = "NY" or STATE not = "NJ" ;
In this example, records that do not meet one condition will meet the other condition.
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Product: . Written by afonso santos 28/10/19 at 00:50:14
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
Copyright © DataEase Limited. All Rights Reserved
