>I made an integer field allow .NULL. and I want to retrieve all records that are greater than zero or .NULL. and exclude the zeroes. Is there anything more efficient than IF ISNULL(myfield) OR myfield greater than 0?
Bret,
Nope! That is the only way if you allow NULLs. Nulls have to be handled specially because of their nature.