endswith function (Databricks SQL)

Returns true if expr ends with endExpr.

Syntax

endswith(expr, endExpr)

Arguments

  • expr: A STRING or BINARY expression.

  • endExpr: A STRING or BINARY expression which is compared to the end of str.

Returns

A BOOLEAN.

If expr or endExpr is NULL, the result is NULL.

If endExpr is the empty string or empty binary the result is true.

The function operates in BINARY mode if both arguments are BINARY.

Examples

> SELECT endswith('SparkSQL', 'SQL');
 true

> SELECT endswith('SparkSQL', 'sql');
 false

> SELECT endswith('SparkSQL', NULL);
 NULL

> SELECT endswith(NULL, 'Spark');
 NULL

> SELECT endswith('SparkSQL', '');
 true

> SELECT endswith(x'110033', x'33');
 true