invalid input syntax for integer in collase( ' ' , 0).

Update tbfacilityreceiptitems set itemID = 13886, Batchno =' 1522' ,mfgdate = '10/20/2013 12:00:00 AM', expdate = '10/20/2016 12:00:00 AM', MRP =200.0000, SingleUnitPrice= 158.0000, marginPercentage = 25.00, sellingprice = 184.80, SaletaxID = 34, TaxPercentage = COALESCE('','0')::int , SaleTaxPercentage =COALESCE('' ,'0')::int , SaleTaxType =' ', sellingpricesku = COALESCE ('','0')::int where facreceiptitemid = 2655

show me the entire code

show me the entire code

My code is give below Update tbfacilityreceiptitems set itemID = 13886, Batchno =' 1522' ,mfgdate = '10/20/2013 12:00:00 AM', expdate = '10/20/2016 12:00:00 AM', MRP =200.0000, SingleUnitPrice= 158.0000, marginPercentage = 25.00, sellingprice = 184.80, SaletaxID = 34, TaxPercentage = COALESCE(0,'') , SaleTaxPercentage =COALESCE('' ,0) , SaleTaxType =' ', sellingpricesku = COALESCE ('',0) where facreceiptitemid = 2655 Please rearrange this code