btrim
function
Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above
Returns str
with leading and trailing characters removed.
Syntax
btrim( str [, trimStr ] )
Returns
A STRING.
The function removes any leading and trailing characters within trimStr
from str
.
Examples
> SELECT 'X' || btrim(' SparkSQL ') || 'X';
XSparkSQLX
> SELECT btrim('abcaabaSparkSQLabcaaba', 'abc');
SparkSQL