>>I'm embarrassed to ask this:
>>
>>I can't figure out how to display a numeric value with the trailing zeroes trimmed. So, if the value is stored in the table as 88.99000, I want the value to display in a report as 88.99.
>>
>>Thanks,
>>
>>Yossi
>
>One possibility
>
>

>alltrim(transform(value), 1, '0') && this will remove trailing zeros but will make this character value

Whoops! Your solution trims significant zeroes as well in say, 890 becomes 89.

How about this solution:

? IIF(AT('.', TRANSFORM(cc)) > 0, alltrim(transform(cc), 1, '0'), TRANSFORM(cc))