4D v13.4

RIGHT

Home

 
4D v13.4
RIGHT

RIGHT  


 

 

Command RIGHTRIGHT (arithmetic_expression, arithmetic_expression)

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

Example  

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

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

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

LEFT