| ARANGE
|
contains a value that falls within a specific alphabetical range |
| BITAND, BITANDHEX, BITANDOFFHEX |
contains a value that results in a nonzero value when a bitwise AND operation is carried out against it |
| BITSET
|
contains a value in a BitFieldType field where the specified bit is set |
| BOOLEANFIELD
|
contains a Boolean agent |
| DISTCARTESIAN
|
contains Cartesian (x/y) coordinates values within a specified distance from a specified point |
| DISTSPHERICAL
|
contains latitude and longitude values within a specified distance from a specified point |
| EMPTY
|
does not exist or does not contain a value |
| EXISTS
|
exists, irrespective of its value |
| FUZZY
|
contains a value that is similar to a specified string |
| MATCHALL or EQUALALL |
contains multiple instances, whose values include at least one match for each of the specified strings or numeric values |
| MATCHCOVER or EQUALCOVER |
contains multiple instances, all of whose values are matched in the specified strings or numeric values |
| MATCHRECURSE
|
contains a specified reference in a ReferenceMemoryMappedType field recursively to a maximum number of times |
| NOTMATCH, NOTSTRING, NOTWILD |
contains multiple instances, at least one of whose values does not match the specified string |
| POLYGON
|
contains Cartesian (x/y) coordinate values within a specified polygonal shape |
| GEOCONTAINS
|
contains a geospatial region that wholly contains a specified point or polygonal shape. |
| GEOINTERSECTS
|
contains a point or geospatial region that intersects a specified point or polygonal shape |
| GEOWITHIN
|
contains a point or geospatial region that is wholly within the specified polygonal shape. |
| STRING, STRINGALL, SUBSTRING |
contains a specified string |
| TERM, TERMALL, TERMEXACT, TERMEXACTALL, TERMEXACTPHRASE, TERMPHRASE |
whose value match specific terms or phrases |