STARTS_WITH_IGNORE_CASE
Description
Returns TRUE if the provided string starts with any of the specified compare_strings(case-insensitive); otherwise, returns FALSE.
Syntax
STARTS_WITH_IGNORE_CASE(string, ...compare_strings) -> Boolean
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| string | String | Yes | The string to evaluate. |
| … compare_strings | String | Yes | One or more strings to check for at the beginning of the source string. |
Example
STARTS_WITH_IGNORE_CASE("FY25-Q2-Report", "fy24", "fy25")
-- Returns TRUE because the string starts with "fy25" (case-insensitive).Tips
An empty compare_strings always returns TRUE since every string starts with an empty string.
Punctuation and symbols are treated like letters.