Simple find on multiple fields

[mowlay]

I'm embarassed to ask this simple question here, but I can't find the answer anywhere else; it's not in the FM help file and I can't formulate a Google or other search for it.

I want to find all records - not in a script etc, just plain Find mode - that contain a specified string *in any field*.

So for example, I want to find all records that mention "India", but I don't know what in what field that will appear (because of previous bad table design and data entry).

At the moment I have having to export to a spreadsheet and search that. Can I do it in FM?

TIA!

[Pupiweb]

Sure !

Two ways:

Script the procedure so that you can create a new find request for each field in which you want to run the search

or (better)

Create a calc field joining all the to-be-searched fields and run the search on that

[mowlay]

That's great; many thanks.