Dave Pfaltzgraff(at)PATAPSCO
08/01/2000 01:50 PM
David Willey <dwilley(at)engr(dot)psu(dot)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.