[thelist] Search engine

[Pete Freitag]

You can do a wild card search using SQL by using the Pattern Matching in the
LIKE statement.

For access
* Match any number of any characters (In many SQL Implementations its %)
? Match one occurrence of any character (Some use _ )
# Any numerical character
[a-k] Match any character in the range a-k
[!a-k] Match any character except for a-k
[adxg] Match a or d or x or g

So you can probably already use wildcards in your search if you used a LIKE
to implement it.

_____________________________________________
Pete Freitag (pfreitag at cfdev.com)
CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Faye Tarzwell(FayeC)
Sent: Friday, October 05, 2001 4:19 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Search engine


Hi Joshua,

This is what I would like to know myself.
They have given me very little information on the job on their first
contact with me.
The only thing I know for sure is that they have an Access database and
all the other info about the search (by title, author, etc.) I got by
taking a look at their site.
It seems to me like a pretty decent search but lacking the wildcard
(don't really know if this is good or bad).
They want to improve customer satisfaction with the search results...
I don't have much info than that.
Any ideas of what to add to it so it become a more robust search engine?

FayeC

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !