• [アーティクル]

LIKE Predicate

Topic Last Modified: 2006-06-13

Use the Structured Query Language (SQL) LIKE predicate as part of a general SQL WHERE Clause to perform character matches. LIKE does a character-by-character comparison of the specified property value and the supplied characters.

propertyName LIKE value

The parameter propertyName specifies the Uniform Resource Name (URN) of the property value in which to check for value. The property URN must be a quoted string. For example, "urn:schemas:mailheader:to".

The parameter value contains the value to check for within the property. The value must be a quoted string, unless the string is comprised strictly of alphanumeric characters [0-9a-zA-Z] with no spaces.

Remarks

LIKE does not work on XML formatted properties, such as resourcetype Field.

Example

WHERE "urn:schemas:mailheader:to" LIKE "someone"

Word and Character Matching

See Also

Other Resources

WHERE Clause