Thanks CraigR
Yes, but I used the GREATEST function to solve the problem:
SELECT *
FROM table1
WHERE GREATEST(col1, col2, col3, col4) IS NOT NULL
<?php if($recordset->TotalRows != 0) echo ' (<span class="red">All necessary Reqmts in place</span>)'; ?>
GREATEST() returns NULL if any argument is NULL.