>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
If I'm understanding your requirement, Ken has pointed you in the right direction. Just a note that the '$' operator is not Rushmore optimizable so depending on the sizes of the tables and fields the query could be slow.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.