SQL Server supports mechanisms that allow you to store large amounts of unstructured text information. In older versions of SQL Server, you had the TEXT data type. With the more modern versions of SQL Server, you can use MAX values with the variable-length character data types VARCHAR and NVARCHAR. This means you can store up to 2GB worth of textual information within a single column. Since a standard index can hold only up to 900 bytes of information, there has to be another mechanism for searching within these large data types. That’s where full-text indexing comes into play.
Full-text search ...