Thread: NOVICE - Wildcard query

Hi,
How does one make a wildcard query? For example:
SELECT * FROM contact_table WHERE fname="Dav*";

Thanks,
David Willey

Dave Pfaltzgraff@PATAPSCO
08/01/2000 01:50 PM

David Willey <dwilley@engr.psu.edu> asks:

>How does one make a wildcard query? For example:
>SELECT * FROM contact_table WHERE fname="Dav*";

Here's where you need the LIKE operator:
SELECT * FROM contact_table WHERE fname LIKE "Dav%";

The underscore '_' matches any single charactetr, the percent sign '%' matches
any sequence of characters.