16.20 - Example: Last Name Spelling - Teradata Database

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

prodname
Advanced SQL Engine
Teradata Database
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1145-162K

This example selects a list of all employees whose last name begins with the letter P.

   SELECT Name 
   FROM Employee 
   WHERE Name LIKE 'P%';

The result returned is:

   Name         
   ----------
   Phan A 
   Peterson J