Re: CONCATENATING A NUMERIC IN RECORD

["Blakeslee, Andy" <ALBlakeslee@HOMELOAN.COM>]

If you convert the numeric field to character prior to padding, it should
work fine.  You can do this in one let statement as follows:

let $fixed_fld = lpad(to_char(&number),10,' ')

this will take a number, convert it to character and pad it to the left with
spaces.  Use rpad to pad it to the right, and change the length and pad
value to whatever is appropriate.

> -----Original Message-----
> From: Bergeron, Marc, Herndon [SMTP:BergeronM@ALPA.ORG]
> Sent: Tuesday, January 12, 1999 1:30 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      CONCATENATING A NUMERIC IN RECORD
>
> Does anyone know how to concatenate a numeric when building a fixed
> length record?
>
>
> I'm getting the field from the database and the length of the data
> changes from record to record.
>
>
> I've been able to pad  character fields with spaces but numerics have
> been more difficult.
>
>
> I have been unable to get the length of a numeric field and when I
> change it to a character
> it changes the data.