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
Related
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for