Concatenate Both Column with Student Code.

;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