update vs4tjobproduction set tjpdstatusorder=0 where tjpdno like 'PD%' or tjpdstatusorder is null
update vs4tjobproduction set tjpdstatusorder=1 where tjpdno like 'PS%' 
update vs4tjobproduction set tjpdstatusorder=2 where tjpdno like 'SD%' 
update vs4tjobproduction set tjpdstatusorder=0 where tjpdstatusorder <> 0 and  tjpdstatusorder <> 1 and tjpdstatusorder <> 2 and  tjpdstatusorder <> 3