Query in VB

I have a database in access ’97 that I manage via a program in Visual Basic 6.0.
In one field called ‘trefwoord’ are several headwords mentioned, often more dan 10 different ones. These headwords are seperated by a ;
But the following of these headwords can change.

e.g.

1. GI; BA; CIV; BTP; POB;
2. BA; W; Z; GI;
3. BTP; WA; Z; W; BA;
4. TAGI; BTP; BA; Z;

Via Visual Basic I will search in the field ‘trefwoord’ the records that satisfy to the criterions GI; and BA; The result of the query should be the record 1 and 2.
How could I program such a query in Visual Basic

Thanks

Try this:


SELECT * FROM TableName
WHERE trefwoord LIKE '%GI;%' AND trefwoord LIKE '%BA;'

However, I'm not that sure if that would work. Let me know about it.

Actually, it should be:


SELECT * FROM TableName
WHERE trefwoord LIKE '% GI;%' AND trefwoord LIKE '% BA;%'