Sunday, 4 March 2012

Using WHERE AND and %

SELECT  LastName FROM Employees
WHERE (LastName NOT LIKE 'A%') AND (LastName NOT LIKE 'B%')

(This will not pick the employees whose last name not starts with A or B)

No comments:

Post a Comment