STRPOS

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the location of a substring within a string.

1strpos(<string>, <substring>)

• <string>: The string to search.
• <substring>: The substring to find.

Returns an integer representing the 1-based position, or 0 if not found.

• Same as position(substring in string) but with reversed argument order.

Locate a substring within a string.

1SELECT strpos('high', 'ig') AS result;

Returns 2.

• String Types