Teradata - POSITION Function - Get Position of Substring in String

POSITION function returns the position (integer number) of a substring in a string.

Quick Example:

Find position of word Jose in string San Jose:

   SELECT POSITION('Jose' IN 'San Jose');
   -- Result: 5

POSITION Overview

Summary information:

Syntax	POSITION(substring IN string)
When Not Found	Returns 0 when substring is not found in string
Returns NULL	If string or substring is NULL
Alternatives	INDEX function that is Teradata extension	Different order of parameters
ANSI SQL	POSITION function is ANSI SQL compliant