I've got a problem concatenating two fields (char(10) not null) in a select statement. Let's say the first field pname has the value
'USER ' and the second field pfirst the value 'JOE '. Then a "select pname||pfirst from table" would return the value 'USERJOE', trimming all spaces in the fields. This behaviour seems to be new in Release 7.4.5. Release 7.3.2 returns 'USER JOE', which makes more sense to me.
Is there any way to get my spaces back?
I'm working on SuSE-Linux 8.2