select * from bi_t_item_info where item_subno like '% %' update bi_t_item_info set item_subno = replace(item_subno,' ','')