Search withih a Document

[giveDsolution]

Can we search the content of document which is uploaded in the database?
For ex, I have a file in database. When i enter some text in the textbox and thn click on the search button...then how it will search the result from the content of the file.

[giveDsolution]

Anone Plz help me out.........

[blackjack2150]

How is this document stored in the database? What kind of database do you use? What is the type of the field used to store the document?

[giveDsolution]

I m using sqlserver2000, The file will be uploaded in the database.
In the database...the filename,filesize,filetype,and the file in binary format is uploaded

[giveDsolution]

can anybody plz help me out

[giveDsolution]

seems to be slient???????\
Can anyone give me the solution?Is it possible or not?

[blackjack2150]

seems to be slient???????\
Can anyone give me the solution?Is it possible or not?

What have you tried? I know that Sql Server has a "Convert" function. So, you could use that function to convert the binary data in your table to plain text and compare with whatever you want in a simple SELECT statement.

Convert function documentation:
http://msdn2.microsoft.com/en-us/library/ms187928.aspx