use hbposev9
go

update t_bd_item_info set num3='0' where len(item_no)>5 and num3 in ('1','2')