dbTalk Databases Forums  

Search Text through Text Column

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Search Text through Text Column in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rogers
 
Posts: n/a

Default Search Text through Text Column - 02-15-2007 , 11:01 AM






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 With Quote
  #2  
Old   
Russell Fields
 
Posts: n/a

Default Re: Search Text through Text Column - 02-27-2007 , 02:58 PM






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
"Rogers" <naissani (AT) hotmail (DOT) com> wrote

Quote:
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 With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.