Thanks, Borislav. That worked a treat. On the ball as usual.
I'd forgotten the NoFilter clause, although I wasn't (to my mind) subsequently querying the cursor per se, rather adding its values to a print table (I suppose that could be interpeted as "querying") However, I'm still confused as to how the spurious filter got there, why it didn't appear after the more complex queries, and the detective in me is itching to know.
Cheers
Terry
>Try to put NOFILTER clause in Your SQL Select
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.