Highlights
All Snippets
Top 100 Snippets
Librarians
gbCodeLib

By Language
VB6
JavaScript
Perl
HTML
SQL
Java
DOS

GBIC >> Source Code >> SQL >> Snippet

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%"