The function LEFT returns the count leftmost characters / bytes in
an expression.
SQL Syntax:
|
|
LEFT( expression,
count ) |
Parameters:
|
|
expression
Any data type of expressions. If it isn't a binary type then it
will convert first to a string data type.
count
The count of characters / bytes that should be return.
|
Escape Syntax:
|
|
{fn LEFT( expression,
count ) } |
Return Type:
|
|
A character string or binary data type depending
of the data type of the expression. |
Examples:
SELECT LEFT( 'Peter', 2 )
Return Values: er
see also:
SQL String Functions
RIGHT
SUBSTRING
|