Basic SQL question

[DrOktagon]

I'm new to Access.

How can I write SQL code that selects records which have a given word somewhere in a text field. The following failed code should give you any idea.

SELECT [ID]
FROM database
WHERE [Title]="*apparatus*";

Thanks much! This board is so great.

 

[boblarson]

SELECT [ID]
FROM database
WHERE [Title] LIKE "*apparatus*";

 

[DrOktagon]

thanks!