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 am also faced with a problem, is there a way for SQL to search through memo fields in all the records in a table?

Thanks,
Tom