endswith function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above

The function operates in BINARY mode if both arguments are BINARY. 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.

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