17.05 - Using WHERE to Filter Character Data - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

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

You can use the WHERE clause to filter character data by searching for a text string.

For example, this statement is processed by searching the employee table for every row that satisfies the condition: the job_title column contains the character string “analyst”. The name and dept_no fields for those rows are then listed.

     SELECT name, dept_no
     FROM employee
     WHERE UPPER (job_title) LIKE '%ANALYST%';