Yes.  But, it's not easy, and you really have to know your data.

WHERE
a.coid LIKE '%' + b.cmpcoid + '%'
AND
c.loccode LIKE '%' + a.location + '%'
AND
a.myeeid = d.ejheeid
AND
a.myeeid = '60K4W0000K0'

Now, what happens if there is a b.cmpcoid like 734, and another like 1734?  This will match the two.  One option is to make the LIKE comparison into '%,' + b.cmpcoid + ',%' instead.  Note the commas.  However, this won't pick up 734 in an a.coid like "325, 734, 986" because of the space.  So, you might have to account for that instead.  There could also be an issue if b.cmpcoid has datatype char, as the LIKE could put the trailing spaces in the comparison, when the trailing spaces aren't in a.coid. 

Look carefully at your data.  Run several test queries, and make sure that you are getting back all the data you expect, and only the data you expect.