LEFT (Lakehouse v1)
Returns the leftmost len characters from the string str, or NULL if any argument is NULL.
Analyze Syntax
Section titled “Analyze Syntax”func.left(<str>, <len>)Analyze Examples
Section titled “Analyze Examples”func.left('foobarbar', 5)┌───────────────────────────┐│ func.left('foobarbar', 5) │├───────────────────────────┤│ fooba │└───────────────────────────┘SQL Syntax
Section titled “SQL Syntax”LEFT(<str>, <len>);Arguments
Section titled “Arguments”| Arguments | Description |
|---|---|
<str> | The main string from where the character to be extracted |
<len> | The count of characters |
Return Type
Section titled “Return Type”VARCHAR
SQL Examples
Section titled “SQL Examples”SELECT LEFT('foobarbar', 5);┌──────────────────────┐│ LEFT('foobarbar', 5) │├──────────────────────┤│ fooba │└──────────────────────┘