LIKE Predicate

  • Article

LIKE Predicate

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release. Use the Structured Query Language (SQL) LIKE predicate as part of a general SQLWHERE Clause to perform character matches. LIKE does a character-by-character comparison of the specified property value and the supplied characters.

Syntax

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

Send us your feedback about the Microsoft Exchange Server 2003 SDK.

Build: June 2007 (2007.618.1)

© 2003-2006 Microsoft Corporation. All rights reserved. Terms of use.