Thanks Sean, Your suggested query works correctly on Fb 1.5 and FB 2.1. I'll modify the queries in our application code and see if our tests pass.
I don't know enough about sql to be able to guess why the original query doesn't work. In assembling the test scripts, it actually worked ok before I added all the column constraints? cheers Paul [Non-text portions of this message have been removed]