Hi,

I have question: how can I in (SQL string) ask DAO to search for records that contain specific data in the value of these records.

I.e.: I have table named "Table1", and it contains one field named "Group_Index" (of type string). This field contains data in the form "x,x,x,x,x,x,x,x" .. where x is a number (of course a string number) for example "2,34,5,6,7,8". I need a query (SQL query) that searches this field for a number for example "2" and returns me this record. The problem is because the field type is string the search is incorrect; consider the following:

I have these records:

"2,3,4,1,6,7"
"22,34,3,5,6,7"
"12,3,7,6,9,0"

if I search the value "2" I would use a query like:

SqlCommand="SELECT ALL FROM [Table1] WHERE [Group_Index] LIKE '*2*'"

unfortunately this query will return me all above mentioned fields because each of them contain "2" (the string). How can strict SqlCommand to search only "2" ???

I appreciate your help in advance,
Thank you

Wesam.

------------------