INSERT INTO nb_seller_master( nb_seller_name, nb_seller_addrress_1, nb_seller_addrress_2, nb_seller_city, nb_seller_state, nb_seller_zip ) VALUES( COALESCE(nb_seller_name_gb, 'No name'), COALESCE(nb_seller_address_1_gb, 'No Address 1'), ...