question

siugoalie78 avatar image
siugoalie78 asked

Full Text Index Covering Multiple Columns

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.
sql-server-2008-r2full-text
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.