Right! Nice piece of lateral thinking. And I can expand this to allow for the first and last in the field:
SELECT * FROM table WHERE (category + ',' LIKE '1,%') OR (',' + category + ',' LIKE '%,1,%') OR (',' + category LIKE '%,1)
Thanks.
Any idea how to get this working for selecting by...