Outdated Version

You are viewing an older version of this section. View current production version.

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

memsql> select left("1234567", 3);
+- -------------------+
| left("1234567", 3) |
+- -------------------+
| 123                |
+- -------------------+

Related Topics

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.