--See records where specific column is NULL SELECT * from table1 WHERE column1 ISNULL --Update all the NULL values in the selected column UPDATE table1 SET column1 = replace_value WHERE column1 ISNULL