IF (SELECT COUNT(0) FROM Seller WHERE Gender IS NULL OR Gender = '') > 0 BEGIN UPDATE Seller SET Gender = 'M' WHERE Gender IS NULL OR Gender = '' END GO