Search Engine Software

Hiya

I have spent countless hours trying to rack my stupid brain to come up with a simple search engine using either Access or SQL
I would like to be able to add a search facility to one of our websites, whereby a user could search for a particular tradesperson, or type of trade

In Just Check we have find a business or trade but I realise that the system is crap and needs some major re-working. What I would like is a database that could hold the info, and a search box where people could type in for example:
Builder

The search engine would then call up the relevant page entries and people could then decide which page to look at. I wish I was brainier but I've spent too long looking for the answers, so I turn to your guys for some help. I usually try and work out this sort of stuff on my own, but my head hurts

Jono wrote: Have you considered SQL Server Full-Text Indexing? Are you after a "Google" style "snippit" of the description? If you have access to install software on the server, there is also the new Microsoft search engine - never used it, but it can't be worse than Index Server!

Jono - If I even understood what you just typed I'd be famous I can install server side code and use it within the site, so what I was aiming for was something "site" controlled and easy to setup (from my point of view) My brain is a bit scrambled from today so I will re-read your reply properly tomorrow and in the mean-time I thank you most sincerely for your prompt reply

Wish I was a lucky programmer
Chat soon

MrTWS

Hiya Jono - I laughed at your reply about talking to you 
What I was hoping to do rather than have an off the shelf package, which in my humble opinion is always rather tying someone to their way of implementing it, was to build a solution myself. I was looking at something similar to this, if I can explain it better:

A database that would hold the information, for example:
Business Name
Business Type
Business Description
Location
Web Address
Email address
Phone Number
Contact Name

Then have a search bar where someone for example might type in - Cleaner and then the search results would filter only that word onto a next page showing the matching businesses. Ideally if one could add say their area (their own location) then the match would show cleaners in their location and not all the cleaners advertising in the site

Does that help? Or is it beyond a simpleton like myself?

It has given me a starting point Jono, and I really thank you for taking "your" time to explain it so clearly. Fancy a job???????????? 
I will start as you have indicated and take one step at a time
Yes I do have access to SQL. Do I build the database therefore using sql rather than access? And if so, do I build it locally (on my Pc) then upload?

Telephone numbers would only be one, rather than multiples

I'll have a look at this over the next few days and may OFTEN come back and pick your brains, if that's okay?
Nite mate