Quick steps: Searching using CONTAINS

Get help searching with CONTAINS in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.

This Content Component encountered an error

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

  1. Open the Query Analyzer from the Start menu.
  2. 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.

This was first published in January 2006

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close