LIKE, CONTAINS and Full Text Indexing

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: michael (michael_at_hockstein.org)
Date: 03/07/04 

Date: Sun, 7 Mar 2004 08:41:05 -0800

I'm interested in searching a column of type text for specific words withing the field. I need the search to be rapid. Currently, I use a LIKE predicate in the RowFilter of a DataView.

For best results, should I explore Full Text Indexing and using a CONTAINS predicate? Would it be best to execute this on the SQL Server rather than from within my application's DataSet? Do I need Full Text Indexing to use CONTAINS?

Michael

Relevant Pages

  • Re: LIKE, CONTAINS and Full Text Indexing
    ... Checkout BOL for more information and a good example for CONTAINSTABLE (that ... > I'm interested in searching a column of type text for specific words ... predicate in the RowFilter of a DataView. ... should I explore Full Text Indexing and using a CONTAINS ...
    (microsoft.public.sqlserver.programming)
  • Re: LIKE, CONTAINS and Full Text Indexing
    ... how many rows in the table that you are currently searching ... Q. Would it be best to execute this on the SQL Server rather than from ... Q. Do I need Full Text Indexing to use CONTAINS? ... > predicate in the RowFilter of a DataView. ...
    (microsoft.public.sqlserver.programming)
  • LIKE, CONTAINS and Full Text Indexing
    ... I'm interested in searching a column of type text for specific words withing the field. ... I need the search to be rapid. ... should I explore Full Text Indexing and using a CONTAINS predicate? ...
    (microsoft.public.sqlserver.programming)
  • Indexing/Searching Chinese
    ... a UTF-8 representation of Chinese. ... Installed the Chinese language packs to the Windows 2000 Server ... With these two items I can get very simple Chinese indexing and searching to ...
    (microsoft.public.inetserver.indexserver)
  • Re: Integration of Lucene.Net and SQL Server 2005?
    ... The field I am indexing and searching is Contents. ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.fulltext)