Chapter 49. SQL Server Full-Text Search


This chapter looks at how to use SQL Server 2005 Full-Text Search (FTS). SQL Server FTS allows you to do extremely fast searches of textual contents stored in columns of the char, nchar, varchar, nvarchar, varchar(max), nvarchar(max), and text data types and binary content stored in image and varbinary(max) data types (if you have an IFilter for the data stored in the image or varbinary(max) data types).

SQL Server FTS has considerable advantages over a search based on a LIKE clause because it is faster, can search binary ...

Get Microsoft® SQL Server 2005 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.