Search Text through Text Column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rogers - 15 Feb 2007 17:01 GMT

I have a Text(datatype) column in one of my table and it contains word
document in binary format and I wanna search text in that column, Can I do
that through any techniques or its not possible through SQL Server 2000
database?

Thanks

Reply to this Message

Russell Fields - 27 Feb 2007 20:58 GMT

Rogers, You may have moved on already, but have you considered full-text
indexing? That should give you the information you need. Some datatypes
need iFilters on the server, but SQL has built in knowledge of many data
formats. - RLF

>I have a Text(datatype) column in one of my table and it contains word
>document in binary format and I wanna search text in that column, Can I do
>that through any techniques or its not possible through SQL Server 2000
>database?
>
> Thanks

Reply to this Message