Concatenate Both Column with Student Code.

Jayakumars
Posted by Jayakumars under SQL Server category on | Points: 40 | Views : 707
;with emp as
(
Select ROW_NUMBER()over (ORDER BY ID)sno,*
from t20
)
select *,LEFT(Firstname,1)+LEFT(LastNAme,1)+CAST(1000+sno AS varchar)as Name from emp

Comments or Responses

Login to post response