Select ' EmpId : '+ cast(EmpId AS varchar)+' Name: '+ Empname +' Address1 : '+Address1 FROM Employee
Login to post response