X-Mozilla-Status: 0001
               Message-ID: <35B2B7B0.B2EDDFED@execpc.com>
                     Date: Sun, 19 Jul 1998 22:21:20 -0500
                     From: Eric Durant <edurant@execpc.com>
                 X-Mailer: Mozilla 4.04 [en] (WinNT; U)
             MIME-Version: 1.0
               Newsgroups: microsoft.public.frontpage.client
                       To: Roland <rm@exacting-craft.demon.nl>
                  Subject: Re: Help: SQL Statement in frontpage
               References: <899910288.14156.0.rover.c30bfff9@news.demon.nl>
             Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

You need to use the LIKE keyword in your WHERE clause, but I've been unable to
get the form field substitution to work properly while passing through the
wildcards.  Also, keep in mind that your ODBC driver may have limitations on
what it can pass through to the DBMS.  I hope this points you in the right
direction.  Please post a followup if you get it to work.

For Access 97, the syntax should be something like:
    WHERE Title LIKE '*%%FormTitle%%*'

-- Eric
   http://www.edurant.com/

Roland <rm@exacting-craft.demon.nl> wrote:

> I'm trying to make a search in a database (movies), and i want that you type
> in part of a field like "name":
>  if you type in alien, it will return with all titels with the word alien in
> it.
> at the moment i only can make it, only by typing the exact name.
> If you can help me with the SQL statement, or what, i need to this, i would
> be very gratefull