like Operator

Returns true if regExpPattern matches aString, otherwise false.

"regExpPattern"

Can be a literal like "abc" or any other regular expression. 

provides an overview of regular expression syntax. "regExpPattern" must be enclosed in double quotes. An introduction into regular expressions can be found at

. 

The example below assigns the boolean result of the relational expression with like operator to variable b1. The expression evaluates to true if the string s1 equals "abc".

set b1 = s1 like "abc";

The example below assigns the boolean result of the relational expression with like operator to variable b2. The expression evaluates to true if the string s2 contains at least one letter and only lower case letters.

set b2 = s2 like "[a-z]+";