Hi Chriastof,
> what happens if you change the order of the test
No difference
> You could drop the index on LEFT(OrdNo,1) if you change the expression to OrdNo = cDept. When SET ANSI is OFF...
Except that this will be running in an ASP/ADO environment where the default for SET ANSI is ON.