[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: CONCATENATING A NUMERIC IN RECORD
you can use a move statement with an edit mask so it will force it to the
format you want. Example:
move &fielda to $char_fielda 09999999999
The above example would result in $char_fielda being zero-filled.
At 01:29 PM 1/12/99 -0500, you wrote:
>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.