This filter limits the external data items returned to those whose value is a match to a string that contains a wildcard character, such as an asterisk (*).
Assembly: Microsoft.Office.BusinessData (in Microsoft.Office.BusinessData.dll)
This filter is similar to the ComparisonFilter except that the comparison is not an exact match but is a comparison to a string that contains a wildcard character.
Users can use this filter type to present more user-friendly filters such as "starts with" and "contains". This filter also insulates the user from having to know what wildcard character the particular external system uses, and how to escape the wildcard itself for a particular external system. For example, SAP uses '*' as the wildcard, and to escape it, the sequence [*]. SQL uses '%' as the wildcard. It does this by providing a single '*' wildcard character and a single \* escape sequence that one would use to actually pass a literal * as input. Metadata authors set the WildcardCharacterEscapeFormat and WildcardCharacter properties on the LobSystem to map these to system-specific wildcard requirements.