testing is (not) empty, null, and number in the where clause