>>> Another observation, which I found in Help file: EMPTY() is not an optimizable function. So, instead of EMPTY() now I use ''<> myfield.
Nadya,
A safer alternative would be;
MyField <> SPACE(LEN(MyField))
because with SET EXACT OFF and SET ANSI OFF '' equals everything.