May 13, 2014

Teradata SQL INDEX function

This is equivalent to ANSI SQL POSITION function.

Example:
SELECT INDEX('Teradata', 'd');    Returns 5  
SELECT INDEX('Teradata', 'er');   Returns 2  
SELECT INDEX('Teradata', 'z');    Returns 0

No comments:

Post a Comment