The following excerpt, courtesy of Que Certification, is from Chapter 10 of the book MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation by Thomas Moore and Ed Tittel. Click for the complete book excerpt series or purchase the book.
STEP BY STEP - 10.11
Executing full-text searches using FREETEXT
- Open the Query Analyzer from the Start menu in Programs, SQL Server 2000.
- To search for all records that contain the word publishing in the pr_info column, regardless of case, execute the following:
USE Pubs GO SELECT pr_info FROM pub_info WHERE FREETEXT (pr_info, 'PuBLiShInG')
Click for the complete book excerpt series.