LEFT

 

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


100% pure Java DBMS
Mirror Site