Pervasive SQL addition of fields where one or more may be null
Posted on 2014-12-17
I'd like to write a query that gives me ((Field A + Field B) - (Field C + Field D))
I get a blank, perhaps NULL, if any of the fields are null. Thus Field A may be 22 but if fields C, D or E are null then the answer appears to be null.