html file to text in column

[Palm]

I have a table and in one column is a html file. I need to to be able query some text that is inside this html file.

What is the best way to take this html file and add the text of the document into another column in the same table?

Palm

[rmiao]

Do you store file or file path in sql table? If stored file in char column in the table, should be able to copy some text to another char column.

[Palm]

It is file and I think it is binary in the coloumn.

[rmiao]

Then you may unable to read text from image column with t-sql.

[Palm]

yes I think so - but arent there any ready made small small software that can do jus this - take text from binayr text or html file and import it again into the table?

[rmiao]

You can use bcp to load data from text file into sql table.