>Thanks Cetin
>
>I tried it and it didn't make any difference.
>
>Any other suggestions
None :( I assume you have indexes already. Similar searches with 100+K records on SQL server returned results under 0.5 seconds on my computer (Athlon 650Mhz, 192Mb).
Cetin