Re: CONCATENATING A NUMERIC IN RECORD

["Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG>]

thanks, Bob

-----Original Message-----
From: Bob Buford [mailto:bbuford@CCCI.ORG]
Sent: Tuesday, January 12, 1999 2:26 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: CONCATENATING A NUMERIC IN RECORD


Marc,

Use the command EDIT(#Var,$format) where
   $format can be '000000...' for the field length.  For other formats
see PRINT edit mask tables.

I typically put the EDIT inside an LTRIM() when concatenating as part of
a select because it usually has a leading space.

HTH

Bob

>>> "Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG> 01/12 1:29 PM >>>
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.