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.