It seems the book discusses FTS with columns that already contain data. The book talks about using FTS with files but doesn't go though how to use this feature.

What I'd like to do is to have a table that contains some meta data about a file. Each row would also contain the full path and file name along with the file type if necessary. It will also contain the full path and file name to the text version of that file. This text version is what I would like to perform the FTS with. Of course there would be hundereds if not thousands of these files, and thus rows in the SQL database.

Is there any resource where I can get step by step instructions on how to setup the table, create the FTS catalog and then perform searches? Of course if you can post such step by step instructions that would work too.

Thanks