I am attempting to create a query that contains 2 files and in file1 i have a field that has parts of company names and i want to get all of the records from file2 that have file1 in file2's company and division fields. How do i do a contains so that if i have 'LEAR' as one of my records in file1 then it will pull up 'LEAR Corp.' and 'cLEARwater Corp' in the company or division fields. Below is what i am attempting to do.

SELECT topcompy.ptcomp, compy.co_compy, compy.co_div ;
FROM Topcompy, compy;
WHERE p_filename.compy CONTAINS sfcomp01.co_compy;
OR p_filename.compy CONTAINS sfcomp01.co_div;
INTO TABLE c:\results.dbf