[NOT] LIKE

Matches an expression to a pattern.

Syntax

expression [NOT] LIKE pattern

Parameters

expression

An expression that evaluates to a character string.

pattern

An expression that evaluates to a character string. Pattern must consist of combinations of letters, digits, symbols, and the special wildcard characters % and _.

Return Value

Logical.

Comments

A LIKE comparison is logically true if expression matches patterns.

A NOT LIKE comparison is logically true if expression fails to match pattern.

Example

compute Employees where LastName like "_a%n"

Processes all records whose LastName values are three characters or more, the second character being an a, and the last character being an n.

find Parts where PartNo like "_ _\\_%"

Finds all parts whose part numbers have an underscore as the third character.

find Parts where PartDesc like "%\\\\%"

Finds parts whose part description contains a backslash.

 

Related Topics