Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Atualizado 07/10/2024
Send us feedback
left
Applies to: Databricks SQL Databricks Runtime
Returns the leftmost len characters from str.
len
str
left(str, len)
str: A STRING expression.
len: An INTEGER expression.
A STRING.
If len is less than 1, an empty string is returned.
> SELECT left('Spark SQL', 3); Spa
right function
substr function