Find all employees where their notes contains any form of the word graduate
SELECT * FROM Employees
WHERE CONTAINS (Notes, 'FORMSOF(INFLECTIONAL, "graduate")')
Wednesday, February 3, 2010
Full text search with FORMSOF
at 6:12 AM
Labels: SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment