O'Reilly logo

Sams Teach Yourself Microsoft by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required