15.9.6 like(string, pattern)

Function returns 'true' or 'false' based on the string matching the supplied pattern. .

Value 1 can be one of the following types: text.

Value 2 can be one of the following types: text.

Returned value type will be boolean.

Function Result

like(client_name, "ADAMS"),

where client name is Cameron Adams

True

like(client_name, "ADAMS"),

where client name is Levi Gray

False