The best way, of course, is not to put any null values in your database

I think using IsNull() is the only easy way out. Of course, you can do one thing: omit this validation for those fields which cannot be null. But otherwise, you don't have much option.