Posted by Alwik on 10/14/05 19:34

Hello
I think that using like it would be impossible.
You will get better results when you use full text search (read about it in
books online), however I have not experience with looking for a phrase, but
with single words it works fast.
Alwik

> I have one table with 300,000 records and 30 columns.
> For example columns are ID, COMPANY, PhONE, NOTES ...
> ID - nvarchar lenth-9
> COMPANY - nvarchar lenth-30
> NOTES - nvarchar length-250
>
> Select * from database
> where NOTES like '%something%'
>
> Is there a way to get results from this query in less then 1-2 second
> and how?
>

[Back to original message]