UPDATE VS4TPointTransMB Set TPoTMoneyNet=TPoTQuantity*CAST(TPoTRate as DECIMAL(9,2)) WHERE TPoTRate <> '' and TPoTRate is not null and CAST(TPoTRate as DECIMAL(9,2)) <> 0
GO
UPDATE VS4TPointTransMB Set TPoTMoneyNet=TPoTQuantity WHERE TPoTMoneyNet = 0 or TPoTMoneyNet is null
GO