Using AND-function inside one field ?

[Arttu Lahdenpera]

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

[Lee Smith]

Enter it like this in your field in the find mode

[Arttu Lahdenpera]

Gee !!

Thanks !!

Arttu

[Wing Fong]

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

[-Queue-]

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

[Lee Smith]

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

[Wing Fong]

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

-w