CODEWITHSUNDEEP
sqlsql-server
hansolo
hansolo

Reputation: 973

Check for Multiple Null Values Across Fields

Trying to check multiple fields for null values in order to create a master field with no null values. In the case below I am attempting to check several "city" fields until I get to a non-null value but this statement is not working as expected. 

CASE
WHEN b.BillingCity IS NULL THEN b.ShippingCity
WHEN b.BillingCity IS NULL AND b.ShippingCity IS NULL THEN c.BillingCity
WHEN b.BillingCity IS NULL AND b.ShippingCity IS NULL AND c.BillingCity IS NULL THEN b.ES_APP__ESCity__c
WHEN b.BillingCity IS NULL AND b.ShippingCity IS NULL AND c.BillingCity IS NULL AND b.ES_APP__ESCity__c IS NULL THEN b.Avn_City__c
ELSE Null
END
As MasterCity

Upvotes: 3

Views: 66

Answers (1)

Lamak
Lamak

Reputation: 70638

You can just use COALESCE:

SELECT COALESCE(b.BillingCity,b.ShippingCity,c.BillingCity,.....)

Upvotes: 6

Related Questions