Hi all, I need to know please If I can use CAST one time for all fields in a calculation in order to get 2 digits. For example :
SUM(CAST((CL.QUANTITE * CL.PRIX_UNITAIRE*(1.0-COALESCE(CL.TAUX_REMISE,0)/100.0) *(1+COALESCE(CL.TAUX_TVA,0)/100.0)) AS NUMERIC(9,2))) AS MONTANT_NET When I use CAST one time it doesn't affect the result calculation as I use CAST for each field ? Thanks