LEFT
Returns the specified characters from the left side of a string.
Behavior Type
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)