startsWith

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

Example

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

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

Syntax

endsWith(string expr field, string find)

Parameters

• field : string expression to search

• find : string expression to find in field

  Returns

  bool

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.