STARTS_WITH

Returns true if the field or expression begins with the specified text, otherwise returns false.

Sample usage

STARTS_WITH(Campaign, "Summer")

Syntax

STARTS_WITH(X, text)

Parameters

  • X - A field or expression of any type.
  • text - The text to find within X. text can be a field, expression, or literal value. text is case-sensitive.

Examples

Example formula Input Output
STARTS_WITH(Campaign, "Summer") Summer Sale true
STARTS_WITH(Campaign, "Sale") Summer Sale false