INDEX Function | VantageCloud Lake - INDEX - Teradata VantageCloud Lake

Returns the position in string_expression_1 where string_expression_2 starts.

• INDEX Function Syntax
• INDEX Argument Types and Rules
• INDEX Result Type and Attributes
• INDEX Usage Notes
• INDEX Function Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Use POSITION instead of INDEX for ANSI SQL:2011 compliance.

For an example of when the two functions return different results for the same data, see How POSITION and INDEX Differ.