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

[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?

 

[Scott]

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!