Using WHERE to Filter Character Data - Teradata Vantage

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%';