Negating and testing  Using nulls in expressions

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Ranges

between is the range-start keyword; and is the range-end keyword. The following range is inclusive:

 where column1 between x and y

The following range is not inclusive:

 where column1 > x and column1 < y




Copyright © 2005. Sybase Inc. All rights reserved. Using nulls in expressions

View this book as PDF