Stephen Pennine ([log in to unmask]) wrote:
: BA is adding a new area code to certain exchanges in Massachusetts and we
: need to update all our databases that carry phone numbers, to correct
: the currently loaded (old) area codes.
: Can anyone provide guidance on any utilities/techniques that will
: search a database, scanning all the fields in all the datasets within
: it, looking for a certain value?  Preferably a wildcard such as
: @phone@ (a caseless search) that would cover instances of fieldnames
: such as 'phone', 'telephone', 'tele-phone', 'phone-no', 'phone#', etc,
: which I've seen searching source libraries.
Query can do most of what you desire.  The FORM command will show all the field
names in a database and the associated sets.  The FIND command with a MATCH
operator
can be used on character items to find those fields that may need to be
updated.

Just redirect the FORM output to a disc file, search that file with your
favorite
search tool. <PLUG ON> HPSEARCH is my favorite (but then I support it) <PLUG
OFF>

Sorry there is no easy way to search ALL fields on a database for a value in
QUERY.

--
 James Overman HP SSG R&D  Roseville, CA