like

Description Syntax Parameters Returns Example
Used to search for a specified pattern in a variable. boolean like(variable, constantString) variable:

Variable for which pattern has to be searched.

constantString:

Pattern string.

The boolean value of the pattern. like(PRODUCTID, 'XYZ%')
Note: The Like operator does not support attributes. It can only be used in sql expression.