Watch the 7.3 Webinar On-Demand

This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

LEFT

Extracts the specified number of characters from the left end of a string

Syntax

LEFT(str, len)

Arguments

str: any string or binary object
len: the number of characters to be extracted

Return Type

String

Examples

SELECT LEFT("1234567", 3);
+- -------------------+
| LEFT("1234567", 3) |
+- -------------------+
| 123                |
+- -------------------+

RIGHT

Was this Article Helpful?

Questions?

Ask the Community, find solutions in the Troubleshooting Overview, get Self-Paced Training or learn more about our Support Plans.