Edit

Share via

Literal Value Comparison

  • Article

The literal value comparison uses standard comparison operators for matching a single-valued column to a literal value. For information about comparing multivalued columns, see Multi-Valued (ARRAY) Comparisons.

The literal value comparison predicate has the following syntax:

...WHERE <column> <comparison operator> <literal>

Note

The right side of the comparison must be a literal. You cannot compare a column against a computed value, and you cannot compare a column against another column.

 

The column part is any valid property column and can be cast to another type if necessary. Optionally, you can enclose the column name in double quotes for readability without affecting functionality. For more information, see Casting the Data Type of a Column.

The literal can be any string, numeric, hexadecimal, Boolean, or date literal, enclosed in single quotation marks. Only exact matches are recognized, and wildcard characters are ignored. The literal can also be cast to another type.

Comparison Operators

The following table describes the supported comparison operators.

Comparison operator Description
= Equal to
!= or <> Not equal to
> Greater than
>= Greater than or equal to
< Less than
<= Less than or equal to

 

 

In conjunction with the "=" operator, Windows Search Structured Query Language (SQL) supports the use of BEFORE and AFTER keywords, which specify whether the query should compare column values before or after a specified value, in dictionary sort ordering.

...WHERE <column> <comparison operator> [BEFORE | AFTER](<https://msdn.microsoft.com/library/Ff637626(v=MSDN.10).aspx>)

Note: to compare dates, you must use DATEADD.

Examples

The following are examples of the literal value comparison predicate.

SELECT System.ItemUrl,System.ItemNameDisplay FROM SystemIndex 
    WHERE System.Title = 'Accounting'

SELECT System.ItemUrl,System.ItemNameDisplay FROM SystemIndex 
    WHERE System.IsFlagged != TRUE

SELECT System.ItemUrl,System.ItemNameDisplay FROM SystemIndex 
    WHERE System.Size >= 10000

SELECT System.ItemUrl,System.ItemNameDisplay FROM SystemIndex 
    WHERE System.Author = BEFORE('m')

Reference

LIKE Predicate

DATEADD Function

Multi-Valued (ARRAY) Comparisons

NULL Predicate

Conceptual

Full-Text Predicates

Non-Full-Text Predicates