update vs4tasset set tassstatusasset=0 where tassstatusasset is null
update vs4tasset set tassTPrjCode='HPPC' where tassTPrjCode='' or tassTPrjCode is null
update vs4tasset set tasslocation=' ' where tasslocation is null or tasslocation = ''
update vs4tasset set tassTAPNCode='A001' where tassTAPNCode is null or tassTAPNCode=''
update vs4tasset set TAssPurDate=TassDateCAlcStart 
update vs4tasset set TAssRefDate=TassDateCAlcStart where TAssRefDate is null
update vs4tasset set TassDateCAlcEnd=TassDateCAlcStart where TassDateCAlcStart>TassDateCAlcEnd


