MessageHi: Well, there are at least two forms of storage to hold textual data. One is VarChar and the other is a Big Field which actually holds a pointer to the large stored text field if I remember. I'm not sure about storing those types of objects other than as these in the DataBase but you could store them as text objects and make sure to restore them as the correct object type by having a code denoting what type was stored in the text field. I'm not sure about other methods of converting them into DataBase format and then back again. If there are better methods someone more experienced will, hopefully, correct me if I'm wrong. ----- Original Message ----- From: Andy B To: programmingblind@xxxxxxxxxxxxx Sent: Friday, October 26, 2007 11:44 AM Subject: sql server 2005 express database design I need to write a program that references, categorizes, indexes and allows searches (including full text searches) on data inserted into the database. Different data formats like Word, rtf, txt, html and other sources would have to be put into the database. Is it easier/better to insert the files themselves (i.e. insert the actual word file) or just the text+formatting of the word file? Any ideas how to do this stuff or where I can find out more?