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