HOWTO USE SQL TO APPEND MEMOS INTO TABLES? HOW TO USE SQL TO SEARCH?

[zetic]

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 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

 

[Rolliee]

Why would you want to append them together?

rollie@bwsys.net