Simple SQL for FrontPage 2000 - SOLUTION

[Andrew Mutch]

Thank you for everyone who contacted me with solutions to this problem.
Several people helped get me going in the right direction.

Jeff Burns started me off on the right track with the concept of CONTAINS
which is actually an option in the FrontPage database wizard.  I then
found a detailed explanation of how to set that up here:

http://www.outfront.net/spooky/search_form.htm

One nice feature of FP2000 is that you can use the wizard to start the SQL
code and then can modify as you need to in the Custom Query section.

The SQL answer to the question was:

SELECT * FROM Ordcoicr WHERE (Author LIKE '%::Author::%')

The "winner" was Paul Peeling who correctly provided the code.  Several
people suggested using the * character in the query as a wildcard.
Although Access uses the * character as a wildcard, apparently, FrontPage
uses the % character, which I believe is standard in SQL.

Now that I'm started, I'll be creating a more complex query that will
allow my staff to search using multiple fields.  Also, it was pointed out
to me and I've discovered that the Capitalization issue was a non-issue -
SQL can handle both.

Thanks again to everyone for the assistance -- this is a great list!

Andrew Mutch
Library Systems Technician
Waterford Township Public Library
Waterford, MI