POSITION

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the location of a substring within a string.

  • <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.

Returns 3, indicating 'om' starts at position 3.

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

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