In String

[DirtyB]

OK, I have two fields in different tables. One field is a Language (i.e. "French&quot. The other field is a Description of a code that represents a group of languages. i.e. the European record would have the data in a memo data type("German, French, Italian, Swedish etc...&quot. I need to select the ID of the Group record if the Language field is included in the string.

So, I need to be able to say if 'French' is in the string 'European.Description' then give me the ID of European Langauge Group. Is there an InString or InStr function that I can use in Access SQL to do this? The like statements(%) don't seem to be working.

Thanks

 

[THoey]

Try an "*":

SELECT tblStrings.id, tblStrings.string
FROM tblStrings
WHERE tblStrings.string like '*french*';

The "%" is used in Oracle (maybe others)... Terry M. Hoey