I have a SQL Server 2008 R2 table with a Full-Text index, covering four columns. If I run a CONTAINS query against that table, searching all columns i.e.: where contains (TABLE_NAME.*,@SearchTerm) Is it possible to have the query return the name of the four column in which the string was actually found? For example, If my Column names are TextA, TextB, TextC, TextD and I am looking for the string 'football', the query would return 'football', 'TextB' or something like that.