Hi Les,
I would also look at enabling full-text search on (I am assuming) SQL Server
and using the CONTAINS clause. You might still have to filter out the 'The',
but it might also help on other situations.
George
On 11/12/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
>
> If "The" is the only word
If "The" is the only word causing you problems, look for it at the beginning
of the search(it would have to be the beginning as you don't want to take it
from the middle of a string) term and remove it before it gets passed to
SQL.
Ade
-Original Message-
From: Les Mizzell [mailto:[EMAIL P
how about a full-text catalog? Is this MS SQL Server?
Another option is to do the search in Verity and then merge the search results
with a database query using the id from the verity collection. Slower than just
SQL alone, but it will get you all the results.
>Let's say I'm searching book ti
3 matches
Mail list logo