Marc,
To search in a memo field you should use the LIKE filter clause, with the "%" wildcard. Check SELECT-SQL in the Help for examples. If you have a lot of memo fields and are constantly doing searches, then you might look into PHDbase which indexes memos.
LIKE can't use Rushmore, so unless you can reduce the total number of records in the main table by limiting other indexed fields it's going to be a slow query.
Barbara
>I have invoice detail in memo field (data is comma delimited) of my main table.
>Also, I have 4 or 5 relation tables to join with the main. The relation tables
>are about hundreds of records. The main table is about thousands. I have to do a search in the memo field of the main table. I want to know what is the best way to search in a memo field with that kind of relation between tables. What kind of SELECT SQL should be used? Is the fonction MLine() is appropriated.
>Any suggestion please...