In this lesson, you learn how to use SQL Server’s full-text searching capabilities to perform sophisticated data querying and selection.
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:
Performance—Wildcard matching usually requires that ...