Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to replace null values in sql

--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
 
PREVIOUS NEXT
Tagged: #replace #null #values #sql
ADD COMMENT
Topic
Name
5+1 =