Skip to Content
0
Apr 21, 2010 at 01:14 PM

FMS and Decimal

30 Views

Hi experts...

I've a little question..

I've a FMS like this:

SELECT (t2.price/(1-(t2.discount/100))  FROM spp1 T2 WHERE T2.[CardCode] = $[$4.0] and T2.[itemcode] = $[$38.1] and $[$38.U_JDT_datarif] between fromdate and todate

I need to display the gross price from the spp1 table. But the FMS return me only 2 decimal.

There is a way to have 5 decimal?

The FMS is apply in the price of the delivery note windows...

Thank's a lot