More genric solutionwill work for any length numbers and also when length of alphabetical part also variesSELECT STUFF( e.emp_id,1,PATINDEX('%[0-9]%',e.emp_id)-1,'') AS supervisor, e.name FROM employee eWHERE exists (SELECT 1 from employee WHERE supervisor = e.emp_id) ORDER BY name;
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs