QBE is very useful but I'd like to extend it to search for something other than partial string matches. I'm not expecting the equivalent of Oracle Forms but does anyone know whether it's possible to search for null values? I'd like to be able to type IS NULL or IS NOT NULL in the form when in QBE mode.

Testing for NOT NULL is possible for string fields. Just enter % in the field during QBE. Testing for NULL is currently not possible with QBE.

------------------
Marco Kalter
Allround Automations