>I have a (hope to be) simple one for you.
>
>I am trying to convert a numeric field with two decimal places into a character field. That is easy enough, but I want to carry over the decimal and the two characters behind it. If I use ALLTRIM(STR(field)) and the record is 200.50 I get 201 in my converted field. I want to see 200.50 not 201.

Another way to convert the numeric field "as is" is to use

ALLTRIM(PADL(YourNumericField, 100, " "))

This expression treats all types of the numeric fields the same way without using the customized parameters as TRANSFORM() function may require.