{{getMsg('Help_YouAreHere')}}: / {{page.title}} {{page.title}}

Like pattern operatorbasicsyntaxcrystalsyntax

This operator compares a specified string x with a string y. If x and y are equals then it returns True. With this operator it is possible to use wildcards in the record selection formula to filter records. The supported wildcards are:

"?" stands for a single character
"*" stands for any number of characters

If the record selection formula is executed on the database, then the wildcards are converted in the SQL statement into "_" and "%". Don't use the wildcard "%" in the record selection formula itself, because it could have a different behavior (result) if the record selection formula is not executed on the database.

Escape characters are not supported. Therefore it is not possible to use strings containing characters, like a "real" question mark '?'.

Usage:

x like y

Returns:

Returns True if the content of x matches the pattern y, otherwise False.

Examples:

{Company.NAME} like "*INC." // returns all records, in that the company name ends with "INC."

{Employees.PostalCode} like '10?69' // returns all records with postalcode between 10069 and 10969

not ({Employees.LastName} like 'T*') // returns all records,
                                        with a last name does not starts with the letter 'T'