Hi David!

Seems to me we are saying virtually the same thing. I'm curious to see your results, but wouldn't want you to put yourself out when it would be easy for Neil to try. Neil has the environment established to test our suggestions.

>Neil,
>
>Do you understand that %x% is not optimizeable under any circumstances? It's going to require a full table scan to see if x exists anywhere in the field. x% can use an index.
>
>I don't know the answer to whether or not ado.net using indexes or rushmore. I can't do any playing with this until tonight. In the meatime maybe someone else with more info will pop into the thread.
>
>>The table I am using is a fpw26 free table (pre-DBC era). I am using the table in a .net application via ado.net. Does ado.net even recognize the index of a free, pre-dbc table.