endswith function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.3 and above

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.

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.5 and above

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