How to make search functions?
View Single Post
10-04-2007, 11:34 AM
Join Date: Apr 2007
To to tie things up a little bit, here's some more information that you might like to know (or might at least entertain reading my post for). The percent symbol (
) in this case is a
character meaning essentially 'zero or more characters'. To build on the above posts, searching for
would match results such as
ape, aperitif, tape, psychotherapeutic
to name a few. This can be a good feature or bad, depending on the circumstances. Generally people know the word that they want to search for and in this case it would be better to only bring back records with the discrete word
, rather than records with words containing the letters
in them. Achieving this won't be covered in this post, but instead I'll move on to what I originally wanted to mention.
As well as the percent wildcard, you can also use an underscore (
) which is another wildcard but behaves differently. Like the percent, it matches any character but this time it will match one, and only one character, rather than 'zero or more'. To give an example, using
would match records;
lapel, paper, apes, drape, 'blue cape'
and so on.
Last edited by Salathe : 10-04-2007 at
View Public Profile
Send a private message to Salathe
Visit Salathe's homepage!
Find More Posts by Salathe