'I want to insert "Not Provided" when null

I want to insert 'not provided' in the column that gets a users contact info. I do not have the user required to give contact information but when I am pulling the data back for reporting purposes I want the report to show 'not provided' instead of being left blank since the value will be null.

How do I write the insert query to make this possible?

sql


Solution 1:[1]

Try this:

UPDATE [table]
SET [column]= 'Not Provided'
WHERE [column] IS NULL;

Where table = your table name And column = your column name

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Nikhil Dada

Related Questions