Skip to Content
0
Former Member
Oct 19, 2005 at 05:30 AM

Concatenating strings with trailing whitespace

215 Views

Hi All,

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?

Thanks,

Sandeep