TRIM(TRIM(PADL(MyNumericField,16),0,"0"),0,".")>I think there is a way to do this but I'm not sure. Suppose you have a number field defined with 2 decimals. You want to print it in a report but truncate any trailing zeros (and the decimal point if both are zero). Is there a formatting technique that would do this?
