Like Operator Example

This example returns a list of employees whose names begin with the letters A through D.

SELECT LastName, FirstName 
FROM Employees 
WHERE LastName Like '[A-D]*';