hi all,
i have some word files and i need them to be stored in SQL database in binary format.
also i may need to open same word file from the database itself.

how to do that?

Now for performing such a task you really need some other front-end tool like Visual Basic, or any other programming language.As far as i know there is no such facility available to achieve something like that in SQL alone.

And further i would ask you to break down your task into smaller subtasks.What you want to do involves various steps.

Hi Kesar,

We have been provided an special datatype IMAGE in SQL Server to store binary data. Create a table with a cloumn of IMAGE datatype, then u can insert any type of file using Simple INSERT statement, like...

INSERT INTO TableName(ColumnName) VALUES('C:\MyData\MyFile.doc')

'C:\MyData\MyFile.doc' is the complete path of ur word file.
But U can not view that file by simply a SELECT statement. You will Have to Use some front-end as CODE_LOVER said earlier.

If U r using Oracle DB, there is BLOB datatype

Akhil