This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

 
Home
4D v20 R8
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';



See also 

LOCATE
POSITION

Previous page
Next page

 
PROPERTIES 

Product: 4D
Theme: Functions

 
PAGE CONTENTS 
Description
Example
 
HISTORY 

 
ARTICLE USAGE

4D SQL Reference ( 4D v20 R8)