hi,
here is a tricky SQL i am not sure it will give correct result set always, but u can use it for ur problem.
Select * from Workers inner join Projects
ON ProjectIds LIKE '%'+CAST(Projec tId AS VARCHAR)+'%'
where ProjectId = 12
it would be better if u can save the projectIds starting and ending with zeros like
0,1,4,2,12,0
but any way its better to change the DB stru...
Leave a comment: