Skip to Content
0
Mar 03, 2009 at 01:43 PM

help to change decimal on a query

26 Views

Hello

I have made the following query

SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[PriceFOB], T1.[Currency], T1.[PriceFOB]*T1.[Rate] as 'Prix Achat FCFA', T1.[Cost], T1.[PriceAtWH] FROM OIPF T0 INNER JOIN IPF1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[ItemCode] >= [%0] and T1.[ItemCode] <= [%1] AND T0.[DocDate] >=[%2] AND T0.[DocDate] <=[%3]

the problem is T1.[PriceFOB] is shown as an integer so instead of 0.69 it shows 1 how to change it to show the 2 digits...

Thank you