Using wildcard characters in columns  “Unknown” values: NULL

Chapter 2: Queries: Selecting Data from a Table

Character strings and quotation marks

When you enter or search for character and date data (char, nchar, unichar, varchar, nvarchar, univarchar, datetime, smalldatetime, date and time datatypes), you must enclose it in single or double quotation marks.

See Chapter 1, “SQL Building Blocks” for more information on character data and Chapter 6, “Using and Creating Datatypes” for more information on date/time datatypes.





Copyright © 2005. Sybase Inc. All rights reserved. “Unknown” values: NULL

View this book as PDF