Hi

This isn’t really a SQL query but it is related to MS SQL Server. We use SQL Server to store the results of surveys some of which have free text questions so produce large text fields as an answer. Does anyone know of a package or tool that can analyse this data from SQL Server? I have looked at SQL Servers Analysis Tool using OLAP but it appears to use closed fields, i.e. the answer can be one of a set as opposed to whatever the user typed in. Am i wrong in this understanding? The sort of analysis we would be looking for is repeated words/phrases etc.

Any advice would be appreciated!

Thanks for help!