LEFT

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11


LEFT (arithmetic_expression, arithmetic_expression)

Description

The LEFT function returns the leftmost part of the arithmetic_expression passed. The second arithmetic_expression indicates the number of leftmost characters to return as extracted from the first arithmetic_expression indicated.

Example

This example returns the first names and first two letters of the last names from the PEOPLE table:

   SELECT FirstName, LEFT(LastName, 2) 
   FROM PEOPLE;

See Also

RIGHT.


4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next