Use is null or is not null in queries on columns defined to allow null values.
An expression with a bitwise or arithmetic operator evaluates to NULL if any of the operands are null. For example, the following evaluates to NULL if column1 is NULL:
1 + column1
Copyright © 2005. Sybase Inc. All rights reserved. |