Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 04, 2022
Send us feedback
left
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