ENDSWITH

The ENDSWITH function determines whether a target string ends with a specified search string. This function returns TRUE if the target string ends with the search string. If the target string does not end with the search string, this function returns FALSE.

Syntax

ENDSWITH('string', 'searchString')

Note: The searchString is case-sensitive. For a case-insensitive search, use the LOWER function on both the search string and the string being searched.

Return

TRUE or FALSE

Examples

ENDSWITH('john@stop.com', '.com') = TRUE
ENDSWITH('john@stop.net, '.com') = FALSE