Problem with concatenation
I have 9 fields with different different lenghts. Now when I am trying to concatinate all the fields just values are concatenated which while displaying give improper results.
Now what I want is if two fields having length of 25 and 15 respectively so on concatinating it should display result as 40 whatever the length of value is there in these fields. Lets take example: -
Text1 = 'Problem' (Char 25)
Text2 = 'Solving' (Char 15)
then result should be 'Problem Solving '
I have already tried Respecting Blanks but it is giving me error saying in character mode or in byte mode or separated by expected.
Edited by: Julius Bussche on Sep 8, 2008 12:20 PM