Pattern search

limited search criteria.  
note can use NOT IN front OF LIKE :
note that LIKE IS CASE sensitive:

SELECT *   FROM  customers   WHERE NAME LIKE "David%"
OR
SELECT *   FROM  customers   WHERE NAME NOT LIKE "David%"