use softdata_01 
 select substring('0000'+substring (cast(item_bar as char(7)),3,5),len('0000'+substring (cast(item_bar as char(7)),3,5))-5,6)
	+'0'+left('0000',6-len(cast(floor(sale_price*100) as varchar(6))))+cast(floor(sale_price*100) as varchar(6))
	+'01'+cast(item_bar as char(7))+'000000030'+RTRIM(cast(item_name as char(12)))+'@ @'
  FROM pub_t_item_info 
  where item_bar like '16%'