Select substr(ename,1,1)||substr(ename,-1,1) name from emp;