O'Reilly logo

Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition 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 learn how to use SQL Server’s full-text searching capabilities to perform sophisticated data querying and selection.

Understanding Full-Text Searching

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 contain specific values or parts of values, regardless of the location of those values within row columns.

But as useful as these search mechanisms are, they have several very important limitations:

Image Performance—Wildcard matching usually requires 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