Another way that you can query your database is through SQL Server 2005 full-text searching, which allows you to query character-based data.
After completing this module, you will be able to:
- Describe what full-text searching is and when to use it
- Describe considerations for full-text searching
- Practice implementing full-text searching
In the next lesson, you will get an overview of full-text searching.
Full-text catalogs are mappings of data that speed the search for specific blocks of text within columns that have full-text searching enabled.
Prior to SQL Server 2008, full-text catalogs were stored external to the database (thus creating some signifi cant backup and recovery issues).
As of SQL Server 2008, full-text catalogs have been integrated into the main database engine and storage mechanisms.
Due to their complex nature, full-text indexes are beyond the scope of this text.
Full-Text Search: This option lets you allow searching of the text within your database.
This is a very useful tool for searching documents or other large text-based data and could be used if you were building a search engine.