4D v14

LOCATE

Home

 
4D v14
LOCATE

LOCATE  


 

 

Command LOCAT LOCATE (arithmetic_expression, arithmetic_expression, arithmetic_expression)

LOCATE (arithmetic_expression, arithmetic_expression)

The LOCATE function returns the starting position of the 1st occurrence of an arithmetic_expression found within a second arithmetic_expression. You can also pass a third arithmetic_expression to specify the character position where the search must begin.

Example  

This example will return the position of the first letter X found in the last names of the PEOPLE table:

SELECT FirstName, LOCATE('X',LastName)
FROM PEOPLE;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
SEE ALSO 

POSITION
SUBSTRING

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)