Comparing character expressions  Including quotation marks in character expressions

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Using the empty string

The empty string ("") or ('') is interpreted as a single blank in insert or assignment statements on varchar or univarchar data. In concatenation of varchar, char, nchar, nvarchar data, the empty string is interpreted as a single space; for following example is stored as “abc def”:

"abc" + "" + "def"

The empty string is never evaluated as NULL.





Copyright © 2005. Sybase Inc. All rights reserved. Including quotation marks in character expressions

View this book as PDF