selecting recs where field1 text is contained in field2

[MontyBurns]

Hi,

I need to return only those records where the contents of field1 is contained in field2. Eg.

Field1 1234
Field2 \\svr\share\folder\1234.pdf

It'll be something like:

SELECT *
FROM tblMyTable
WHERE Field2 Like *Field1*

But this doesn't work. Any ideas anyone?

Thanks,
Burns

 

[vb6novice]

Monty,

The criteria row for Field2 should contain

((InStr(1,[Field2],[Field1])<>0));

When you run the query and then go back to the design view, Access will have converted this criteria to another field that has just InStr(1,[Field2],[Field1]) in the Field row and <>&quot;0&quot; in the criteria row.