{SOLVED} Using the LIKE operator in SQL

[Number 5]

Hi

I am encountering some problems with SQL. I am trying to create a search query where a person enters some keywords into a textbox called "Subjects2" on a form called "Doc_search" and is presented with a list of possible records from a table "Document_corr2". I don't think that SQL likes the code I used. I don't get any syntax errors but it doesn't give any records. I have tried several combinations of ', %, * etc.

Thanks in advance for your help - I am an engineer, not a programmer, so I am not quite sure how to handle this problem.

SELECT *
FROM Document_corr2
WHERE Subject LIKE '& %[Forms]![Doc_search]![Subjects2]% &'
ORDER BY contract_no, Date_Issued;

[Number 5]

Don't worry, I worked it out:

SELECT *
FROM Document_corr2
WHERE Subject LIKE '*' & [Forms]![Doc_search]![Subjects2] & '*'
ORDER BY contract_no, Date_Issued;