String functions
POSITION
Reference material for POSITION function
Returns the position of the substring found in the string, starting from 1. The returned value is for the first matching value, and not for any subsequent valid matches. In case the substring does not exist, functions will return 0.
Syntax
Parameters
Parameter | Description | Supported input types |
---|---|---|
<substring> | The substring to search for. | TEXT |
<string> | The string that will be searched. | TEXT |
Return Type
INTEGER
Example
Returns: 1
Returns: 7
Returns: 0