endswith
function
Applies to: Databricks SQL 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 ofstr
.
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