case statement to evaluate null values syntax

[staceyn]

Hello,
I am trying to figure out how to write the following query in SQL if anyone can help

Use field A if not blank othrewise use field B, if field B is blank print "N/A"

Thanks

 

[bborissov]

SELECT COALESCE(NULLIF(FieldA,''), NULLIF(FieldB,''), 'N/A')
FROM YourTable

th fieldA or FieldB can not be empty, just NULL, then there is no need to use NULLIF() function.

Borislav Borissov
VFP9 SP2, SQL Server

 

[staceyn]

Thanks so much will give this a try