Full-text search, an extension of SQL Server 7.0, supports textual queries on data residing in the SQL Server database or in file systems. The CML application applies full-text search to the SQL Server database tables only. To effectively direct and focus searches of the F & M library the developers decided to enable three tables in the database for full-text search, author, subject, and title. The following topics provide more information: