Skip to main content

LEFT function

Returns the specified characters from the left side of a string.

Syntax

LEFT(string, length)

Arguments

  • string: a string expression.

  • length: an integer value that specifis how many characters to return.

Returns

A string, that contains specified characters from the left side of the input string. If length is less than or equal to 0, returns an empty string.

Examples

> SELECT LEFT('CeloSQL', 3);
 Cel