>>>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')
>
>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))
>
Good point I forgot to consider :) :Luckily it was not my own bug and you (internal developer) found it before the clients did :)
If it's not broken, fix it until it is.
My Blog