LEFT

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

Behavior Type

Immutable

Syntax

LEFT ( string‑expr, length )

Parameters

string‑expr

The string expression to return.
length

An integer value that specifies how many characters to return.

Examples

=> SELECT LEFT('vertica', 3);
 LEFT
------
 ver
(1 row)

 SELECT DISTINCT(
   LEFT (customer_name, 4)) FnameTruncated 
   FROM customer_dimension ORDER BY FnameTruncated LIMIT 10;
 FnameTruncated
----------------
 Alex
 Amer
 Amy
 Anna
 Barb
 Ben
 Bett
 Bria
 Carl
 Crai
(10 rows)

See Also

SUBSTR