The full-text search feature of Microsoft SQL Server delivers enterprise search functionality integrated into the database. Significant enhancements in the areas of performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size.
SELECT Column_Name
FROM Table_Name
WHERE FREETEXT (Column_Name, 'Search_Text' );
GO
Submit an article or tip