LEFT

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

Behavior Type

Immutable

Syntax

LEFT ( string , length )

Parameters

string

(CHAR or VARCHAR) is the string to return.

length

Is an INTEGER value that specifies the count of characters to return.

Examples

=> SELECT LEFT('vertica', 3);
 LEFT
------
 ver
(1 row)
=> SELECT LEFT('straße', 5);
 LEFT
-------
 straß
(1 row)

See Also