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.