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.12
Searching using CONTAINS
- Open the Query Analyzer from the Start menu.
- To search for different forms of the word Publish in the pr_info column, execute the following:
USE Pubs GO SELECT pr_info FROM pub_info WHERE CONTAINS(pr_info , ' FORMSOF (INFLECTIONAL, publish) ')
Click for the complete book excerpt series.