The following example uses the LIKE predicate to select a list of employees whose job title contains the string “Pres”:
SELECT Name, DeptNo, JobTitle FROM Employee WHERE JobTitle LIKE '%Pres%' ;
The form %string% requires Teradata Database to examine much of each string x. If x is long and there are many rows in the table, the search for qualifying rows may take a long time.
The result returned is:
|Watson L||500||Vice President|
|Phan A||300||Vice President|