The symbol * in a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have been asked to design a query from a table and then use the symbol *
to search for items beginning with a particular code number. I have no idea
what the * function means - can anyone help?

Many thanks
 
The asterisk acts as a wild character. I have never used them myself but
there are a few message threads on here that may answer what you are looking
for.
 
Someone told you in designing a database that they want you to use a
particular function when performing a search. Hmmmm sound more like
homework to me. I can't imagine a boss telling me to build a database and
use particular functions to perform searches.

Do you not have previous lectures or notes that tell you how to do this?
Have you consulted the help files?
 
Hi - many thanks for your advice
--
Gill


scubadiver said:
The asterisk acts as a wild character. I have never used them myself but
there are a few message threads on here that may answer what you are looking
for.
Click to expand...
 
Damn! :-)




RBear3 said:
Someone told you in designing a database that they want you to use a
particular function when performing a search. Hmmmm sound more like
homework to me. I can't imagine a boss telling me to build a database and
use particular functions to perform searches.

Do you not have previous lectures or notes that tell you how to do this?
Have you consulted the help files?

--
Hope that helps!

RBear3
..
Click to expand...
 
Hi there

I was doing this task as part of the ECDL course to help me at work and the
tutor was unsure what the * in the question meant. I did try the help files
and went round in circles. I'll wait till the next session and then go back
over the CD in case I've missed it. Many thanks for your advice.
 
As you got in the previous post the * used as a wild card

In the query fields criteria you can write

Like "123*"
Will return all the records that start with the number 123

Like "*123"
Will return all the records that end with the number 123

Like "*123*"
Will return all the records that has the number 123 in it, any where
 
Back
Top