database query without exact match

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

Guest

i would like to be able to query a database of fruit descriptions (mostly
qualitative) and get all entries that are exact to the query, as well as
similar (ie to account for difference of opinion between all of the people
making the subjective entries).
 
I wasn't sure if you are looking for exact match or not
To get the exact match
Select * From TableName Where Fieldname Like [Please enter a string to search]

Without exact match, the string can be any where in the field
Select * From TableName Where Fieldname Like "*" & [Please enter a string to
search] & "*"
 
On Tue, 15 Nov 2005 09:08:03 -0800, "Jane Wilcox" <Jane
i would like to be able to query a database of fruit descriptions (mostly
qualitative) and get all entries that are exact to the query, as well as
similar (ie to account for difference of opinion between all of the people
making the subjective entries).
Click to expand...

If the description is "sugary" and you want the word "sweet" to
match... you're asking too much of the poor computer. It has no human
intelligence of course; it's just a very fast idiot.

The LIKE suggestions in the thread will work to find specific text
strings embedded in a longer description, but I wonder if that's what
you want. Could you give a couple of examples of "near match"
descriptions?

John W. Vinson[MVP]
 
Back
Top