Re: HOWDOI: Output Variable Length Fields (Re: rtrim not triming)

If I understand what you are trying to do, you need to concatenate the fields together rather than use a comma separator. An example would look like this

Select fld1 || fld2 from table1;

This of course assumes both fields are char type. If you are concatenating numbers together you may have to do some additional work with conversions. The concatenation symbol is the vertical bar (twice).

Dave

Eric M. Gamble <emgamble_at_rwxc.com> wrote in article <01bc0910$43ec0800$a5b093cf_at_egamble>...
> I have tried everything from RTRIM to selecting the SUBSTR of the LENGTH
 to
> achieve the following output:
>
> 10~FIELD2~~SOME TEXT
> 101~FIELD2~EXTRA INFO~SOME MORE TEXT
> 1~FIELD2~INFO~LITTLE TEXT
>
> I keep getting:
>
> 10 FIELD2 SOME TEXT
> 101 FIELD2 EXTRA INFO SOME MORE TEXT
> 1 FIELD2 INFO LITTLE TEXT
>
> I do not what fixed length records. I need variable length records. How
> do I do this?
>
>
  Received on Thu Jan 30 1997 - 00:00:00 CET