(Like) Operator for partial searches using wildcard '%' and '_' For Example: Select * From Employees Where last_name LIKE '_a%';