Replace

Saranya Boopathi
Posted by Saranya Boopathi under Sql Server category on | Points: 40 | Views : 963
Replace function :

 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

Comments or Responses

Login to post response