startsWith

Returns true if a string expression field starts with a specific substring, find.

Syntax

startsWith(string expr field, string find)

Parameters

  • field : string expression to search
  • find : string expression to find in field

Returns

bool

Example

Find all countries in the expression COUNTRYNAME_ that start with the ‘n’ character.

startsWith(SALES.COUNTRIES.COUNTRY_NAME,"n")

Notes

Function startsWith evaluates field then searches for find at the beginning of field. If find is found it returns true. It returns false otherwise. This means if find is found, but not at the beginning of field, startsWith returns false.

Function startsWith is not case sensitive.