query to fetch the employee name with department id inserted at the 4th position of the employee name

Posted by Bandi under Sql Server category on 1/30/2015 | Points: 40 | Views : 1241

SELECT concat(LEFT(EMPNAME,4),deptid,right(empname,(len(empname)-4)))
FROM employee

Bookmark It

Latest Code Snipptes