You cannot look for just "2:" because "12:" will also satisfy that condition. Try
SELECT * FROM mytable ;
WHERE (":2:" $ (":" + items) ) OR (":8:" $ (":" + items) ) ;
INTO CURSOR crsResult
>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
--sb--