[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.