10-31-2014 05:39 PM
Is there a way to concatenate several fields, and if they are empty have length = 0 or nulls?
I am trying to execute the following and always comes back with length of 1, even though fields are empty..
ALLVARS = LENGTH(COMPRESS(CATS(FIELD1,FIELD2,FIELD3,DATE1,DATE2),'00'X));
the compress is there because sometimes I have binary zeroes on the dates.
I just want to execute a process in case the fields have values and another one if they don't.
how can I solve it?
10-31-2014 05:45 PM
forgot to say, all the fields are defined as characters.
It always comes back with a length of 1...
Not understanding why is that..
Need further help from the community? Please ask a new question.