If I give you a rotten tomato, will you throw it in the face of the total idiot who designed that database?
Yes, you can do it. It's sneaky, but possible.
The problem you have is avoiding "false positives".
For example, say that the victimOf field contains "23,37" and the chrgSeq field is "3". If you simply do
(don't worry yet about how to do that), you can see that you would get a "false positive" on both the "23" and the "37".
WHERE victimOf LIKE '%3%'
So the (very very ugly!) answer is to transform that to this:
And now you don't get any false positives but you will get a correct positive for (examples) either
WHERE ',23,37,' LIKE '%,3,%'
WHERE ',3,37,' LIKE '%,3,%'
WHERE ',23,37,' LIKE '%,23,%'
SELECT * FROM table
WHERE ',' + victimOf + ',' LIKE '%,' + CONVERT(VARCHAR(20),chrgSeq) + ',%'
How about a rotten tomato and a rotten egg?
Oh...and the only way to preserve spaces in this (and in most) forums is to wrap your text in [ code ] ... [ /code ] tags (even if it's not really code...and of course no spaces in the actual tags).