EQL accepts all Unicode characters.
<Literal> ::= <StringLiteral> | <NumericLiteral>
String literals | String literals must be surrounded by
single quotation marks.
Embedded single quotes and backslashes must be escaped by
backslashes. Examples:
'jim' 'àlêx\'s house' |
Numeric literals | Numeric literals can be integers or
floating point numbers.
Numeric literals cannot be surrounded by single quotation marks. Numeric literals do not support exponential notation, and
they cannot have trailing f|F|d|D to indicate float or double.
34 .34 |
Boolean literal |
TRUE/FALSE Boolean literals cannot be surrounded by single quotation marks. |
Literals of structured types (such as Date, Time, or Geocode) |
Literals of structured types must use appropriate conversions, as shown in the following example: RETURN Result AS SELECT TO_GEOCODE(45.0, 37.0) AS Geocode, TO_DATETIME('2011-11-21T08:22:00Z') AS Timestamp |
Identifiers |
Identifiers must be NCNames. The NCName format is defined in the W3C document Namespaces in XML 1.0 (Second Edition), located at this URL: http://www.w3.org/TR/REC-xml-names/. An identifier must be enclosed in double quotation marks if:
If an identifier is in quotation marks, then you must use a backslash to escape double quotation marks and backslashes. Examples:
"Count" "Sales.Amount" |