SQL Server : replace null value

Question

In SQL Server, how to write a query in case ItemType = MD5 then replace Null value as 'NAM' ?

 Country ItemType
  Null    MD5

sagi · Accepted Answer · 2016-06-19 08:06:49Z

2

SELECT CASE WHEN t.ItemType = 'MD5' THEN 'NAM' ELSE t.country END as [Country],
       t.itemType
FROM YourTable t

If you want it only to be replace when Country is NULL, then replace it with this:

CASE WHEN t.ItemType = 'MD5' AND t.country IS NULL THEN 'NAM' ELSE t.country END

answered Jun 19, 2016 at 8:06

sagi

40.6k7 gold badges66 silver badges87 bronze badges

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

1 Answer 1