Replace Id with Name based in comma seperated string in SQL Server

Hi ,

i have department table.

columns DeptID,Dept_Name.

1- Sales

2-finance

3-IT

i have department table.

i have columns in employees table like

EmpID,EmpName,Emp_Departments.

In Emp_Departments column i am storing value like 1@,2@,3.

Now i need a query to display all employees information with relevant departments name as a result.

Thanks in advance.