select * from ( select ItemID, REPLACE(Screen,1,'SE') c1, REPLACE(Screen,2,'TR')c2, Replace(Screen,3,'AV')c3, Replace(Screen,4,'LV')c4 from #screen) a join Screen b on a.ItemID=b.ItemID
Login to post response