Parameter | Type | Description |
---|---|---|
string | string | the string to take the leftmost characters of |
num_chars | integer | the number of characters to get |
Returns: string
Example
query:
SELECT LEFT("alphabet", 5)
results:
left |
---|
alpha |
The string function used to find the n leftmost characters of a string.
Parameter | Type | Description |
---|---|---|
string | string | the string to take the leftmost characters of |
num_chars | integer | the number of characters to get |
query:
SELECT LEFT("alphabet", 5)
results:
left |
---|
alpha |
CONCAT
, ENDSWITH
, LENGTH
, LOWER
, LPAD
, LTRIM
, MID
, REGEXP_EXTRACT
, REPLACE
, REVERSE
, RIGHT
, RPAD
, RTRIM
, SUBSTRING
, STR_AFTER
, STR_CONTAINS
, STRING_SPLIT
, STARTSWITH
, TRIM
, UPPER