question

how do I fix this error: Conversion failed when converting the varchar value '99.9' to data type int. in this query: select c.duns, cast(round(a.g1p_1/100,2)as varchar)* D_AR + cast(round(a.g1p_2/100,2)as varchar)* D_AR + cast(round(a.g1p_3/100,2)as varchar)* D_AR + cast(round(a.g1p_4/100,2)as varchar)* D_AR as G1P_GP from Raw_Survey_Data_Test. dbo.S3000_GP a inner join Raw_Survey_Data_Test. dbo.S3000GP_CompanyInfo b on a.RESPNUM = b.respnum inner join Raw_Survey_Data_Test.dbo.MOD_SHIP c on b.duns=c.duns