>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

try this:

FilterList = "2:"

select * ;
   from parts ;
   where ;
      "2:" $ subs(parts.Items, 1, 2) .or. ":2:" $ parts.Items .or. ;
      "8:" $ subs(parts.Items, 1, 2) .or. ":8:" $ parts.Items

hope this helps