STARTS_WITH
Returns true if the first string starts with all the characters of the second string.
Usage
STARTS_WITH(source, match, ignoreCase)
Parameters
source |
String |
The string to search. |
match |
String |
The string to match. |
ignoreCase |
Boolean |
Pass true if the case doesn’t matter, false otherwise. |
Returns
Boolean
Examples
STARTS_WITH(‘Hello’, ‘he’, true) |
true |
STARTS_WITH(‘Hello’, ‘he’, false) |
false |
Remarks
STARTS_WITH(“Hello”, “he”, true) returns true because the different case is ignored, but STARTS_WITH(“Hello”, “he”, false) returns false.