Prefix match query

SELECT FirstName, LastName FROM EMPLOYEE
WHERE LastName LIKE 'Sm%' ;

This query returns all the Smarts, Smetanas, Smiths, and Smurfs. LastName is probably a good field to index.