>Hi All,
>
>I am faced to deal with a client's existing database. In the database, there are a couple of tables, table A and table B. All the table structures are the same, both have a memo field. Now, using UNION, I would like to append these two tables together, unfortunately, is very simlar to OLE objects, Is there a way to do this? -- I have tried using the regular SQL which errors me

I'm not sure what kind of problem you have because UNION works for tables with Memo fields. However UNION requires that fields were in the same order in both tables and have the same size.

SELECT * FROM tablea ;
UNION ALL ;	
SELECT * FROM tableb

What error do you get?

>I am also faced with a problem, is there a way for SQL to search through memo fields in all the records in a table?

You can use "$" operator. Keep in mind that it cold be slow on big table because query cannot use indexes in this case.

SELECT * from mytable ;
  WHERE "MYSTRING" $ UPPER(mymemo)