[thelist] sql and databases

Ken Schaefer ken at adOpenStatic.com
Fri Aug 13 21:38:25 CDT 2004


You do not need Index Server. SQL Server has the same technology built in - 
check Books Online.

Cheers
Ken

----- Original Message ----- 
From: "Andrew Martin" <comitque at hotmail.com>
Subject: Re: [thelist] sql and databases


: Yeah, that's a good idea.  How about Index Server?  I haven't used it 
before
: (and I have no idea how useful/useless it may be) but I do have access to
: it.
:
: Thanks!
:
: ----- Original Message ----- 
: From: "Peter Brunone (EasyListBox.com)" <peter at easylistbox.com>
: To: <thelist at lists.evolt.org>
: Sent: Friday, August 13, 2004 3:12 PM
: Subject: RE: [thelist] sql and databases
:
:
: >
: > Is this a SQL Server database?  You might look into full-text
: > searching.
: >
: > -----Original Message-----
: > From: thelist-bounces at lists.evolt.org
: > [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Andrew Martin
: >
: > I am working on a site for a record store.  They have a database full of
: >
: > artist names and album titles.
: >
: > Using ASP, I currently use LIKE as a sql term, so SELECT * WHERE artist
: > LIKE
: > '%" & searchterm & "%'"
: >
: > If someone searches for "JOHNNY CASH AND THE FUNKY FRESH BAND" and the
: > actual artist title is JOHNNY CASH WITH THE FUNKY FRESH BAND, no results
: >
: > appear.
: >
: > "johnny cash funky fresh" also would not turn up any results because
: > that
: > exact phase is not in the database.
: >
: > How do I perform a more complicated search?  Are there tutorials
: > anywhere
: > for this?
: >
: > Thanks!



More information about the thelist mailing list