Does text begin with fragment?
Returns a Yes/No
value as follows:
TRUE
if the text fragment is found at the beginning of the search value.FALSE
if the text fragment is not found at the beginning of the search value.
Note: The search is case-insensitive: upper- and lower-case letters are equivalent.
Sample usage
STARTSWITH("aBc", "a")
returns TRUE
STARTSWITH("aBc", "bc")
returns FALSE
(Bc
occurs, but not at the beginning)
STARTSWITH("aBc", "D")
returns FALSE
(D
does not occur)
STARTSWITH("I'm bored!", "Red")
returns FALSE
(red
occurs, but not at the beginning)
STARTSWITH([Email], "noreply@")
answers the question: does the Email
contain an address to which messages shouldn't be sent? Functionally equivalent to but more efficient than ("noreply" = ANY(SPLIT([Email], "@")))
. See also: ANY()
, SPLIT()
Syntax
STARTSWITH(text-to-search, search-for)
- text-to-search - Text to be searched.
-
search-for
- Text string to search for intext-to-search
.
See also