EQUALS_IGNORE_CASE
Description
Returns TRUE if the value matches any of the given compare_values (case-insensitive); otherwise, returns FALSE.
Syntax
EQUALS_IGNORE_CASE(string, ...compare_strings) -> Boolean
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| string | String | Yes | The value to be compared. |
| … compare_strings | String | Yes | One or more values to compare with the given value. |
Examples
EQUALS_IGNORE_CASE("ny", "CA", "NY")
-- Returns TRUE (case-insensitive).EQUALS_IGNORE_CASE(Status, "in progress", "completed")
-- Returns TRUE if Status is "in progress" or "completed" (case-insensitive); otherwise, returns FALSE.