POSITION

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the location of a substring within a string.

1position(<substring> in <string> [, start => s] [, occurrence => n])

• <substring>: The substring to search for.
• <string>: The string to search within.

• start: The position to start searching from.
• occurrence: Which occurrence to find (nth occurrence).

Returns an integer that represents the 1-based position of the substring, or 0 if not found.

Locate a substring within a string.

1SELECT position('om' in 'Thomas') AS result;

Returns 3, indicating ‘om’ starts at position 3.

Locate the second occurrence of a substring within a string starting from position 16.

1SELECT position('sea' in 'Sally sells sea shells by the sea shore, how many sea shells did she sell?')

Returns 51, indicating that the second ‘sea’ after position 16 starts at position 51.

• String Types