[thelist] sql and databases

[Peter Brunone (EasyListBox.com)]

	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! 
--