适用于：
Databricks SQL Databricks Runtime
从 str中删除前导或尾随空格字符。
删除 trimStr中开头或结尾的 str 字符。
语法
trim(str)
trim(BOTH FROM str)
trim(LEADING FROM str)
trim(TRAILING FROM str)
trim(trimStr FROM str)
trim(BOTH trimStr FROM str)
trim(LEADING trimStr FROM str)
trim(TRAILING trimStr FROM str)
参数
-
trimStr：一个STRING表达式，其中包含一组要剪裁的字符。 -
str：一个要剪裁的STRING表达式。
返回
STRING。
示例
> SELECT '+' || trim(' SparkSQL ') || '+';
+SparkSQL+
> SELECT '+' || trim(BOTH FROM ' SparkSQL ') || '+';
+SparkSQL+
> SELECT '+' || trim(LEADING FROM ' SparkSQL ') || '+';
+SparkSQL +
> SELECT '+' || trim(TRAILING FROM ' SparkSQL ') || '+';
+ SparkSQL+
> SELECT trim('SL' FROM 'SSparkSQLS');
parkSQ
> SELECT trim(BOTH 'SL' FROM 'SSparkSQLS');
parkSQ
> SELECT trim(LEADING 'SL' FROM 'SSparkSQLS');
parkSQLS
> SELECT trim(TRAILING 'SL' FROM 'SSparkSQLS');
SSparkSQ
> SELECT trim(BOTH 'sl' COLLATE UTF8_BINARY FROM 'SSparkSQLS');
SSparkSQLS
> SELECT trim(BOTH 'sl' COLLATE UTF8_LCASE FROM 'SSparkSQLS');
parkSQ