4D v13.4

POSITION

Home

 
4D v13.4
POSITION

POSITION  


 

 

Command POSITION

POSITION (arithmetic_expression IN arithmetic_expression)

The POSITION function returns a value indicating the starting position of the first arithmetic_expression within the second arithmetic_expression. If the string is not found, the function returns zero.

Example  

This example will return the starting position of the word "York" in any last names of the PEOPLE table:

SELECT FirstName, POSITION('York’ IN LastName)
FROM PEOPLE;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

LOCATE
SUBSTRING