Filter Query in SQL

Question

Hi,

I have a table Employee

Emp_No int

Emp_Name nvarchar(50)

Emp_DeptNo nvarchar(150)

 

Emp_No	Emp_Name	Emp_DeptNo
1	A	1, 2 , 3, 5
2	B	2
3	C	4, 5

 

Here i want to filter by Emp_DeptNo Where Emp_DeptNo in (3, 5) then result will be

 

Emp_No	Emp_Name	Emp_DeptNo
1	A	1, 2 , 3, 5
3	C	4, 5

 

How to filter this

 

Thanks

Basit.