title: Join two tables in mssql with column int and varchar having comma seperated values
body: <p>I have 2 tables as tblemployee and tbllead . My issue is in tblemployee i have column <strong>id</strong> as a integer value  and tbllead column <strong>leademployees</strong> having varchar with comma seperated value.</p>
  
  <p>So when I am joining this two table i am facing problem.
  <strong>select * from tblemployee as e join tbllead as l
  on e.id=l.LeadEmployees</strong></p>
  
  <p>Getting:- Error converting data type varchar to bigint.</p>
  
  <p><a href="https://i.stack.imgur.com/OnL2q.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OnL2q.jpg" alt="MY Table Structure"></a></p>
  
  <p>My desired result should have all the columns values except 4.
  Thanks in Advance...</p>