Hi All,

I have a column in the table that looks like this

Items
-----
1:2:4:7:9:12:
3:4:6:8:10:11:13:
2:4:8:9:12:14:
6:9:13:17:22:

I want to select all rows where Items contain 2: or 8:. I started with
select * from parts where atc("2:",parts.Items)>0. This select statement only give me row 1,3,4 (row 4 because of 22:). How can I modified the select statement to include 8: using one select statement? Is this possible?
TIA