4D v18

SUBSTRING

Home

 
Home
4D v18
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.

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';



Siehe auch 

LOCATE
POSITION

Vorige Seite
Nächste Seite

 
EIGENSCHAFTEN 

Produkt: 4D
Thema: Functions

 
SEITENINHALT 
Description
Beispiel
 
GESCHICHTE 

 
ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v18)