find recds having certain substr

[ntambomvu]

Hello There
I am sure this has been asked before by i dont know the terminology.
I have a field in my table called "Keywords". this field contains a string
made up of different words . so a record called "food" could have the
following content in Keywords "breadmeatbuttermilkeggsjamfruit"
(the string may be as long as 128 characters).
what is the command and syntax in the query for the keywords column
if I only want records containing "eggs"
(I used to program in dbase and the function was $"eggs" which translates
to string contains the substr "eggs")
Help will be sincerely appreciated
Regards
Fred Evans

[Micron]

Use the LIKE operator in the keywords field of the query design grid. LIKE "*eggs*" will find a record with that word. You have to consider the effect of wildcards and their placement because *egg* will also find begging and arpeggio.

[ArviLaanemets]

SELECT * FROM YourTable WHERE Instr(Keywords,"eggs")>0