>>Hello.
>>
>>I have a field like this Cantidad n(16,6)
>>
>>sometimes the user writes 1345.9 4505.103 5413.44
>>
>>but when I print the field in the report writer the output is
>>
>>1,345.900000
>>4,505.103000
>>5,413.440000
>>
>>I don't want to show the last zeroes in the decimal part.
>>
>>I've been trying to do that with Transform but I can't find a way.
>>
>>c.x.
>
>you may try alltrim(padr(myNumber,16))
Nope,
This doesn't remove the trailing zeros.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.