Lesson 17. Full-Text Searching

In this lesson, you’ll learn how to use SQL Server’s full-text searching capabilities to perform sophisticated data querying and selection.

Understanding Full-Text Searching

Note: SQL Server 2005 Only

This lesson covers full-text searching using SQL Server 2005. Previous versions of SQL Server do support full-text searching, but SQL Server 2005 changed and enhanced this feature so significantly that much of the content covered in this lesson won’t apply to those earlier versions.

In Lesson 8, “Using Wildcard Filtering,” you were introduced to the LIKE keyword, which is used to match text (and partial text) via wildcard operators. Using LIKE, it is possible to locate rows that ...

Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial