4D v13.4

SUBSTRING

Home

 
4D v13.4
4D SQL Reference
Functions
SUBSTRING

SUBSTRING  


 

 

Command SUBSTRINGSUBSTRING (arithmetic_expression, arithmetic_expression, [arithmetic_expression])

The SUBSTRING function returns a substring of the first arithmetic_expression passed. The second arithmetic_expression indicates the starting position of the substring and the optional third arithmetic_expression indicates the number of characters to return counting from the starting position indicated. If the third arithmetic_expression is not passed, the function will return all the characters starting from the position indicated.

Example  

This example will return 4 characters of the store name starting with the 2nd character:

SELECT SUBSTRING(Store_name,2,4)
FROM Geography
WHERE Store_name = 'Paris';

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

LOCATE
POSITION