IIRC, it was suggested to use PADL(FIELDNAME,20) instead of TRANSFORM() in one of previous discussion.

>That was quite dense, and I would split up the RETURN line for readability. < g > Plus your results can be defeated by the actual value in the field. In the Invoices table in the NW DBC, I get no decimals using TRANSFORM() on the discount field regardless of the overall value of the field unless at least one of the decimal places has at least 1 non-zero value.
>