Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

PLEASE. SEARCH HELP. HELP

0 views
Skip to first unread message

Ivan V Canalejo

unread,
Jun 23, 2000, 3:00:00 AM6/23/00
to
I need help in the following issue:

I'm using SQL Server 7.0

I'm searching for a variable string [strSearch] on field description on a
table.

The sql statement used is:

select description from table where description like '%' + strSearch + '%'

My question is:

Does anyone know how to speed up this search on the database side.?

Please any suggestion is appreciated.


0 new messages