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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » 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.

 Set the quoted_identifier option off for the current user ID
  • Enter the following statement:

    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