A literal is a string of characters that represents a value in a query statement. You use literals to compare column values or to specify search terms. Microsoft SharePoint Portal Server Search (SharePointPSSearch) supports the following types of literals.
String literals are not limited in length, and can contain either American National Standard Institute (ANSI) or Unicode characters. You must enclose string literals in single quotation marks. To include a single quotation mark inside a string literal, use two single quotation marks. Represent an empty string as two consecutive single quotation marks (' ').
Numeric literals can contain the digits 0-9, a period, and the letter E (or e). Numeric literals represent numbers, including positive and negative integers, decimal numbers, and currency values. Numeric literals can be defined by using scientific notation (for example, 2.3E-05). Do not enclose a numeric literal in single quotation marks, or it is interpreted as a string literal and is compared by using string comparison techniques. Currency values cannot contain currency symbols.
Hexadecimal literals can contain the digits 0-9 and the letters A-F and a-f. A hexadecimal literal represents an unsigned integer specified in hexadecimal notation. Hexadecimal literals must begin with 0x.
Note The SQL-92 standard requires that hexadecimal literals be enclosed in single quotation marks, however, SharePointPSSearch does not support that notation.
Boolean literals represent logical values, and can be either TRUE or FALSE. Do not enclose a Boolean literal in single quotation marks, or it is interpreted as a string literal.
Date literals represent specific dates, time stamps, or relative times, and are enclosed in single quotation marks. You must put dates in the form year/month/day or year-month-day, where the month, day, and year are numbers. Specify the year with a four-digit value, for example, 2004. Time values must be in the form hours:minutes:seconds. Relative time syntax is based on the DATEADD function.