Ranges  Comparisons that return TRUE

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Using nulls in expressions

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. Comparisons that return TRUE

View this book as PDF