update vs4tcomsale set tcostype=0 where tcosno like 'CM%'
update vs4tcomsale set tcostype=1 where tcosno like 'CMQ%'
update vs4tcomsale set tcostype=2 where tcosno like 'CMT%'
update vs4tcomsale set tcostype=3 where tcosno like 'CMM%'