Invalid use of Is operator. (Error 2443)

The Is operator is used to determine if an expression is Null. You can use the Is operator in an expression only with NULL or NOT NULL.