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:
Performance—Wildcard matching usually requires that ...
Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition 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.
