Creating searchss with Wildcards

  • Thread starter Thread starter Tom Burton
  • Start date Start date
T

Tom Burton

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
 
Yes, this where you would create a query that uses the Like statement with a
Where statement.
Aircode: Exact syntax would be trial/error.

Select Location from tbltrains Where [Location] Like & "input textboxname" &
"*"

I don't use FrontPage to connect database, I use ASP instead. I would search
in FrontPage or the Internet for creating queries using Like.
 
Back
Top