what criteria to use for a query

[Guest]

The field is phone #. I want to run a query to pull all records where the
number 2 is part of the phone number. what is the correct criteria wording?
thanks as always. BTW, Does it matter if the data type for phone numbers is
"text" or "number"?

 

[Jerry Porter]

Bob,

The criteria would be: Like "*2*"

It should work if the data is text or number, but I would advise
storing phone numbers as text.

Jerry

 

[Guest]

It doesn't matter if the field is a number or text data type; use the
criterion:

Like "*2*"

Ken Sheridan
Stafford, England

 

[Guest]

thanks Jerry: It worked fine. How does one go about learning these various
expressions (jargon). I'm new at this. It's a bit intimidating- like learning
a new language. Is there certain condensed Material, tutorial etc? I just
need to learn some basics. Nothing to complicated. Thanks again.

Bob Levin

 

[Jerry Porter]

You might try reading a book that covers basic tasks. You can also read
in the Help in the Getting Started section. But there a quite a lot of
things that could be considered "basic", so it also takes time and
experience.