You wrote:
*******************************************
Hi,

Can somebody tell me how to speed up search on a book title column
(varchar(100)), the user will be usually entering first 2 or 3 words of the
title. What I am using now is LIKE, but this is very slow on a table which
contains 120000+ records.

Any suggestion are greatly appreciated.

Thank you.

Sudheer
********************************************

I don't know how it would work for you, but I use a separate table for
something like this in a shopping cart application. I juse fill the table
with relavent keywords from the field I want to search (excluding things
like "is", "and", "I", "or", etc) and search on those. Of course each
keyword in the separate table has a FK to actual record of the table the
keywords are derived from.

Sorry couldn't be much help.

Lee