LastName LIKE '[A-K]*' for one case, and
LastName LIKE '[L-Z]*' for the other case.