<< Interesting thought but I refuse to futz with the EQNULL option. It is not standard SQL and can have unwanted side effects. >>
You can do this more or less safely like this:
SET VAR vSaveEQNull = (CVAL('EQNULL'))
SET EQNULL ON
IF <<Condition Here>> THEN
-- Do Stuff
ENDIF
SET EQNULL &vSaveEQNull
CLEAR VAR vSaveEQNull
As long as your confident in the IF statement and the nested code, this will do
what you want without endangering the database wide EQNull setting.
--
Larr
