Concatonating 7 string and 1 numeric field

Using the GUI would make this fairly straight-forward but...

The concatenation operator comes in two flavors:
1) | weak concatenation
2) || hard concatenation

The difference is that the hard concatenation will move trailing blanks to the end of the concatenated string but weak concatenation will preserve trailing blanks.

The EDIT function is often used to convert numeric to alpha.

Remember that the receiving field must be of sufficient size to accomodate the result of the concatenation or EDIT.

HTH

Thank You very much Jim.

I've got the concatenation working for the alpha fields but I still havn't able to figure the EDIT function for the conversion of the numeric field to alpha. If you or someone can provide me with a sample code, I would very much appreciate this. Thank you once again.

abutony

If the numeric is an integer the EDIT(IntField) should work. If number is floating point then FTOA (Float to Alpha) or DTOA (Double to Alpha) should work.