Gene Wirchenko seemed to utter in news:124n63tul0d1lptj9u419dni7jmpt68obr@[EMAIL PROTECTED]
>>***** Start of Included Code *****
> "Giancarlo Piccinato" <piccinato@[EMAIL PROTECTED]
> wrote:
>
>>And this is a more polished version:
>
> [snip]
>
> I am quite capable of writing something to do it, but I was
> hoping that there was a point I was overlooking. Is there a way to do
> this with one function call?
Well, the help file for TRANSFORM() says that it is supposed
to remove trailing zeros from the decimal part of numeric
values, but that can be easily demonstrated as not true.
If TRANSFORM() worked as advertised, you'd be home free.
Since it doesn't, you may need to write a little code that
removes trailing blanks from strings that contain a decimal
point. Then you can just:
? DropTrailingZeros(TRANSFORM(5.30))
Look on the bright side, at least the solution is easy!
-- TRW
_______________________________________
t i m . w i t o r t
_______________________________________
|
