I am looking for the cleanest syntax to use to do the following:
I am using a CASE statement for this but want a clean way to handle it:
I need to concat the 4 fields together based on this logic:
FIELD1 [space] FIELD2 [space] FIELD3 [space] FIELD4 [space]
- If any of the fields are NULL or EQUAL TO 'N/A' I want to skip that field in the concatenation. So need to handle the null value
- If ALL 4 fields are NULL or EQUAL TO 'N/A' I want to skip the concat completely and use the value 'Not Available'