You should use GREATEST/LEAST, this function returns NULL if at least one value is NULL.

So this code:

select * from TABLE where LEAST(COLUMN_1, COLUMN_2, COLUMN_3, COLUMN_4) is not null

will only return results if all columns are non-null.