'Find' in a field is one word search or exact match only?

  • Thread starter Thread starter shelley kline
  • Start date Start date
S

shelley kline

Hi there,
Does anyone know how to make the 'find' function look for
more one word in a field without having to be an exact
title match?

I can only seem to get the database to search by one word
key - it's very slow.

Are there any other wild card characters that the find
function will recognize? Is there anyway to fix this?
 
If you are using 'find' from the edit menu, you can use
wildcards:

? Any single character
* Zero or more characters
# Any single digit (09)
[charlist] Any single character in charlist
[!charlist] Any single character not in charlist

If you are using code or a query, try:

like "*{term1}*{term2}*"

Hope this helps!
 
Back
Top