|
|
|
|
|
|
|
|
|
|
version 11
POSITION (arithmetic_expression IN arithmetic_expression)
Description
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;
See Also
|
|
|
|
|
|
|
|
|
|