How To Remove Null Values in SQL from Multiple columns?

Question

I have enormous amount of null values accross my SQL tables and it takes forever to remove them Column by Column. Is there a shortcut to replace all Null values with "N/A" Text.

    Column1 Column2 Column3 Column4
row 1   David   **Null**    15th Dec    $5666
row 2   **Null**    Director    10th JAN    $9500
row 3   John    Janator **Null**    $1000
row 4   Steve   Market  6th FEB **Null**

Why do you want to do this? It is adding to you DB size without adding any value to the data stored there. — Declan_K
– Declan_K, Commented Sep 5, 2013 at 14:49

Robert · Accepted Answer · 2013-09-05 14:27:02Z

3

Maybe this way:

update tab
set Column1 = coalesce(Column1,'N/A'),
    Column2 = coalesce(Column2,'N/A'),  
    Column3 = coalesce(Column3,'N/A'), 
    Column4 = coalesce(Column4,'N/A')

answered Sep 5, 2013 at 14:27

Robert

25.8k8 gold badges70 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How To Remove Null Values in SQL from Multiple columns?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related