| description |
|---|
Searches for the first occurrence of the substring in the given expression and returns the position of where the substring begins. Searching binary values is also supported. |
- expression: The expression to search.
- substring: The substring to search the expression for.
Examples
{% code title="STRPOS example" %}
SELECT STRPOS('spice cloud service', 'cloud')
-- 8{% endcode %}
{% code title="STRPOS example" %}
SELECT STRPOS(1001111, 00)
-- 2{% endcode %}
{% code title="STRPOS example" %}
SELECT STRPOS('spice cloud service', 'sql')
-- 0{% endcode %}
If the substring is not found, the function returns 0. The data type of both parameters must match; specifically, they should both be either strings or binary values.