Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification » Queries » The WHERE clause: Specifying rows


Character strings and quotation marks

When you enter or search for character and date data, you must enclose it in single quotes, as in the following example.

SELECT GivenName, Surname
   FROM Contacts
   WHERE GivenName = 'John';

If the quoted_identifier database option is set to Off (it is On by default), you can also use double quotes around character or date data, as in the following example.

SET OPTION quoted_identifier = 'Off';

The quoted_identifier option is provided for compatibility with Adaptive Server Enterprise. By default, the Adaptive Server Enterprise option is quoted_identifier Off and the SQL Anywhere option is quoted_identifier On.

 Quotation marks in strings
 See also