Like

docs model reference
1

This expression will compare a string to another string using wildcards.

Function Parameters

Left

Expression to compare

Possible children:

  • Data Constant
  • Field reference
  • Function
  • Filter reference
  • Lookup reference

Right

Expression to compare (wildcards allowed).

Possible children:

  • Data Constant
  • Field reference
  • Function
  • Filter reference
  • Lookup reference

Wildcards

You can use the following wildcards inside the following wildcards:
% This wildcard replaces any number of characters. E.g. "Name LIKE ‘%Smith’ will return all people where the last letters in the name are “Smith”.
? This wildcard replaces a single character. E.g. "Category LIKE ‘b?g’ will return the following categories: “bug”, “bag”, “big”.