[firebird-support] How to use CAST

[m_brahi...@yahoo.fr [firebird-support]]

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