What wildcard charectar do I use to retrieve all records from a qu

[John W. Vinson]

*


For a more detailed answer, please post a more detailed question. Feel free to
use the big textbox, not just the subject line.

John W. Vinson [MVP]

 

[David W. Fenton]

On Fri, 17 Aug 2007 12:42:01 -0700, Mark

*

For a more detailed answer, please post a more detailed question.
Feel free to use the big textbox, not just the subject line.

Actually, your answer is not quite true. If you want to return all
records with a *non-null* value in that field, yes, LIKE * is what
you need to do. But if you want the null values, too, you should
just leave out any criteria at all (LIKE * Or Is Null is the same
thing as no criteria at all).

On the other hand, if you want all values matching a certain value
and all those with no value, you'd use Is Null and the non-null
value you want to filter on (with or without the LIKE operator).

Allen Browne has excellent pages on the secrets of Null.