4D v13.4

LEFT

Home

 
4D v13.4
LEFT

LEFT  


 

 

Command LEFLEFT (arithmetic_expression, arithmetic_expression)

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;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

RIGHT