12-05-2013 05:17 AM
where AGE =>65 OR AGE<12;
I want to have a dataset with records that have AGE=>65 or AGE<12, but the above code doesn't work.
I get this in the log:
ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
|a missing value, INPUT, PUT.|
ERROR 76-322: Syntax error, statement will be ignored.
12-05-2013 06:58 AM
You need >= or (and I never say always but) I always use mnemonics GE.