Check the index, it may have an expression like alltrim(wono) or something like that, if so change the SELECT to the same.
Also, you won't get full optimization unless you have an index on DELETED()
Also, SET EXACT ON and SET ANSI ON and see what happens or use alltrim(wono) == "0"
>
>=SYS(3054,11)
>USE woentry
>SELECT * FROM woentry WHERE wono = "0"
>
Rushmore optimization level for table woentry: none?TAG(4),KEY(4)
WONO WONO>
>What conditions could cause the query not to be optimized??
>
>Thanks to all......Rich
Regards N Mc Donald