I was wondering if it is possible to use SQL queries such as IS NOT NULL
I am looking for something similar to
Trim(A + ’ ’ + B + ’ ’ + C + ’ ’ + D + (( ‘&’ + ’ ’ + E + ’ ’ + F + ’ ’ + G + ’ ’ + H)IS NOT NULL))
I get an error
invalid expression Trim(A + ' ' + B + ' ' + C + ' ' + D + (( '&' + ' ' + E + ' ' + F + ' ' + G + ' ' + H)IS NOT NULL)) :1:136 - 1:138 unexpected Ident while scanning parentheses expected ")"
Basically A-D are all required and the rest are optional, I only want to show the optional columns if there has been information input, I am looking for the cell to ignore whitespace but as corteza does not allow for full SQL queries I am trying to find a work around?