Creating searchss with Wildcards

Hi

I have a website created using Microsoft FrontPage XP, I use a database
results table to fetch reports from a Microsoft access database.

http://www.bonelogger.co.uk

basically search for locomotive number 58050 and you are presented with a
list of sightings of that particular loco,

with the location box if you want to search you type in the location name
I.E. Acton Stn,

However there are several variations on Acton, Acton Stn, Acton TMD, Acton
Mainline, Acton Yard

The users have requested that they would like to be able to do a wildcard
search

something along the lines of typing "Acton*" and getting results for all the
Acton locations.

I cannot seem to find an option to allow this! do I have to build a custom
query? if so how do I go about this and getting a search area....

TIA

Tom

Kathleen
Sat Jun 19 06:44:31 CDT 2004

From: http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

Using the Begins With comparison:

If you choose Use this search form field, the SQL statement looks like this:

SELECT * FROM Categories WHERE (CategoryName LIKE '::CategoryName::%')


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Tom Burton <tom@nospam.net> wrote:
> Hi
>
> I have a website created using Microsoft FrontPage XP, I use a
> database results table to fetch reports from a Microsoft access
> database.
>
> http://www.bonelogger.co.uk
>
> basically search for locomotive number 58050 and you are presented
> with a list of sightings of that particular loco,
>
> with the location box if you want to search you type in the location
> name I.E. Acton Stn,
>
> However there are several variations on Acton, Acton Stn, Acton TMD,
> Acton Mainline, Acton Yard
>
> The users have requested that they would like to be able to do a
> wildcard search
>
> something along the lines of typing "Acton*" and getting results for
> all the Acton locations.
>
> I cannot seem to find an option to allow this! do I have to build a
> custom query? if so how do I go about this and getting a search
> area....
>
> TIA
>
> Tom