CONTAINS_IGNORE_CASE
Description
Returns TRUE if the provided string contains any of the specified compare_strings, ignoring case differences. Otherwise, returns FALSE.
Syntax
CONTAINS_IGNORE_CASE(string, ...compare_strings) -> Boolean
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| string | String | Yes | The source string to search within. |
| ...compare_strings | String | Yes | One or more strings to search for within the source string. |
Examples
CONTAINS_IGNORE_CASE("Annual Financial Review 2024", "Quarterly", "financial")
-- Returns TRUE ("financial" matches, case-insensitive).CONTAINS_IGNORE_CASE(Subject, "Urgent", "ASAP")
-- Returns TRUE if Subject contains "Urgent" or "ASAP" in any case; otherwise, returns FALSE.