I am trying to understand why searching for a partial text string in
FM5 only finds text occuring either immediately at the beginning of a
field or after a space (beginning a word).

I have a DB listing schools that our company services

Searching for River will result in

River Public SChool
Riverdale School
South River Elementary School

but searching for Dale will not display Riverdale.

Why? is there anyway that I can create a script to do that?



S

FM searches by word, as you described.

When in the find mode, there's a little drop-down in the status area called
"Symbols", for operators you can use in a search.

One of this is an asterisk, which means "zero or more characters". If you
search for *dale, you'll find:

Riverdale school
Chip and Dale's School of Comedy
Dale's Stripper school for Chippens

--

Shadenfroh
shadenfroh (AT) yahoo (DOT) com

"Steven Bitaxi" <sbitaxi (AT) yorku (DOT) ca> wrote

That's funny. I've been working on scripting everything that I forgot
about that little bit of functionality. "Hey! How about wildcards?"

Thanks, and my apologies.



S