Get Text From Image Data Type Column By using FTS

Hi,
I m using Sql Server 2000 Full Text Search. I hv a table with a
column of image data type .
Full Text Search is working fine on this column. But it is only
returning Binary Data.
I want to show Search results in text format. I want to get my
Searched pharase/word in simple text format. Is this possible by using
FTS?
Regards
Sohaib
No, its not possible. You would have to extract the text value from the
image column and store it in a separate varchar(max) or text datatype column
and then iterate its contents for the hit.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sohaib" <hafizsohaib@.gmail.com> wrote in message
news:1159791947.351151.274960@.k70g2000cwa.googlegr oups.com...
> Hi,
> I m using Sql Server 2000 Full Text Search. I hv a table with a
> column of image data type .
> Full Text Search is working fine on this column. But it is only
> returning Binary Data.
> I want to show Search results in text format. I want to get my
> Searched pharase/word in simple text format. Is this possible by using
> FTS?
> Regards
> Sohaib
>