Synonymous keywords  Adaptive Server login accounts

Chapter 1: SQL Building Blocks

Treatment of nulls

The set option ansinull determines whether or not evaluation of null-valued operands in SQL equality (=) or inequality (!=) comparisons and aggregate functions is SQL-standard-compliant. This option does not affect how Adaptive Server evaluates null values in other kinds of SQL statements such as create table.





Copyright © 2005. Sybase Inc. All rights reserved. Adaptive Server login accounts

View this book as PDF