Token Formats
Topic Last Modified: 2006-06-13
The Exchange store Structured Query Language (SQL) uses the concept of token values for search conditions in the SQL WHERE Clause. Tokens must be delimited by single quotation marks. A token can contain only alphabetic characters unless they are surrounded by double quotation marks. In the following WHERE Clause, "this" and "that" are tokens:
WHERE CONTAINS (' "this" AND "that" ')
This clause does not work:
WHERE CONTAINS ('10 dollars')
To fix the clause, surround the token with double quotation marks within the single quotation marks:
WHERE CONTAINS ('"10 dollars"')