| Parameter | Type | Description |
|---|---|---|
str | string | the string to search |
substring | string | the substring to search for |
Returns: string
Example
query:
SELECT POSITION("y", "Amaryllis")results:
| position |
|---|
| 5 |
The POSITIONfunction requires two arguments. The first argument is the substring whose position is to be determined. The second argument is the string to be searched.