0
Reply

sellingpricesku = COALESCE ('','0')::numeric

aravinth kandasamy

aravinth kandasamy
Apr 7 2015 3:27 AM
530
Error is  invalid input syntax for type numeric: ""


How to solve this problem.My Code is


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')::numeric , SaleTaxPercentage =COALESCE('' ,'0')::numeric , SaleTaxType =' ', sellingpricesku = COALESCE ('','0')::numeric where facreceiptitemid = 2655


Please help me

Next Recommended Forum