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]*';