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')

Return

TRUE or FALSE

Examples

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