I am working with a database (not mine) where the values in the field can be some thing lke:
Code:
ID | FIELD
----------
1      2,4,6
2      23,42
3      2
4      32, 33
etc...
I need to be able to grab the rows based on one of the values separated like 2 but not get 23. And I can't assume a comma like '2,' because 2 could be the final number or part of 32,. I'm hoping this is doable in the query so I can avoid having to grab them all and process seperately.

Thanks,

baze