I have a String 'ABC XYZ ' which has a trailing space character. This string has to be concatenated with another string '1234'. The expected output is
'ABC XYZ 1234'
I'm using the concatenate function but the whitespace after XYZ is getting truncated and the output is coming as 'ABC XYZ1234'. I tried concatenating a whitespace also
CONCATENATE 'ABC XYZ' ' ' '1234'INTO temp.
but the result is the same. Does someone have a solution?