The sql-expressions must be of compatible data types. They must be either all numeric or all character types. Because a BETWEEN condition evaluates the boundary ... You can use the NOT logical ...