Hi everybody !

Is there any possibilities to perform a find using AND-operand inside one field ? I mean...

If I have records with a field "Story_text"

Record1: "A cat climbed to a tree"

Record2: " A cat jumped over the moon"

Record3: "A horse run away"

Record4: " A cat fell from a tree"

Now I need to perform a search which would return Records 1 and 4 which both include words "cat" and "tree":

Find: "cat" AND "tree"

Is it possible at all ?

Cheers

Arttu

Enter it like this in your field in the find mode

Gee !!

Thanks !!

Arttu

Hi, I've changed this post a bit.

How can you do the above, but instead of it searching for "cat" AND "tree", make it search for "cat" OR "tree"?

I'm trying to write a script that will search for one of two words in a field and return all records with one or other of those words.

Thanks! -wing

Separate requests will do the trick. One request searches for "cat", the second for "tree".

It's calle New Record Request.

In the find mode, enter Cat in your first find request, and then do a New Record Request and enter Tree in the Second Record Request.

Lee

ahh...I see. I can write that into my script. Thanks!

-w