17.10 - Example: Applying INDEX to the SPACE Character - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

In this example, INDEX is applied to ' ' (the SPACE character) in the value strings in the Name column of the Employee table.

   SELECT name 
   FROM employee 
   WHERE INDEX(name, ' ') > 6 ; 

INDEX examines the Name field and returns all names where a space appears in a character position beyond the sixth (character position seven or higher).