Export (0) Print
Expand All

Searching for Any Form of a Specific Word (Generation Term)

SQL Server 2000

Searching for Any Form of a Specific Word (Generation Term)

You can search for all the different tenses of a verb or both the singular and plural forms of a noun. For example, this query searches for any form of dry (dry, dried, drying, and so on) in the Description column of the Categories table.

USE Northwind
GO
SELECT Description, CategoryName
FROM Categories
WHERE CONTAINS (Description, 'FORMSOF(INFLECTIONAL, "dry")')
GO

Note that a single term cannot be used to match both nouns and verbs in the same query.

Show:
© 2014 Microsoft