Contains Or Something Similiar

I am a ColdFusion developer who has been self taught in MS SQL. Something I am trying to do that should be very easy is killing me. I can do this in a couple different calls to the DB but feel I should be able to do it in one. Here is what I have/want...

I have in my DB a field that contains a comma sep. list. I am sending to a page url.id. That ID contains one number that I want to find in that field.

I can NOT use LIKE bc field might be...
1,2,3,4
1,2,3,11,12

URL.ID might be 1 so with LIKE it would find the 1 and 11 etc

I have tried...
CONTAINS (Field, 'URL.ID') Which would work but CONTAINS ignores numbers from what I am reading (and the error message says this).

Any help greatly appreciated. I just need someone to help me with this Where Clause.

Thanks again Chris