left function

Applies to: Databricks SQL Databricks Runtime

Returns the leftmost len characters from 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