当输入或搜索字符和日期数据时，您必须将其括在单引号中，如以下示例所示。

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

如果 quoted_identifier 数据库选项设置为 Off（缺省设置为 On），则还可以使用双引号将字符或日期数据括起来，如以下示例所示。

SET OPTION quoted_identifier = 'Off';

提供 quoted_identifier 选项是为了与 Adaptive Server Enterprise 兼容。缺省情况下，Adaptive Server Enterprise 选项 quoted_identifier 设为 Off，而 SQL Anywhere 选项 quoted_identifier 设为 On。

 字符串中的引号

'I don''t understand.'

"He said, ""It is not really confusing."""

'George said, "There must be a better way."'
"Isn't there a better way?"
'George asked, "Isn''t there a better way?"'

 另请参见