like

Returns true if a string pattern can be found in a given string.

Example

Get number of times the country name contained in U shows up in a given table.

count(like(Sales_Acme.Countries.COUNTRY_NAME, 'U%'))

Syntax

like(string expr field, string pattern, [string esc])

• field : string expression to search
• pattern : string to search for

• esc : string

  Returns

  boolean

Notes

Function like takes field and searches for an instance of pattern. It returns true if it finds pattern in field and stops searching. If pattern is not found in field, like returns false.