Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
salman4u
Starting Member
2 Posts |
 Posted - 2009-11-16 : 00:14:46
|
| Hello,i created a full text index on my tblContactQuestions. The fields of which are : UserId,PrimaryEmail,SecondaryEmail,HomePhone,MobilePhone,PrimaryAddress,SecondaryAddress,TownCity,State.And created full text index on PrimaryEmail,SecondaryEmail,HomePhone,MobilePhone,PrimaryAddress,SecondaryAddress,TownCity,State.When i run this query :-Select *From tblContactQuestionsWhere FREETEXT(*,@SearchPhrase) It gives me correct result. But my requirement is that i dont want to select *, instead i want to select that column's data in which the @SearchPhrase is found, i mean the select COLUMNNAME(this columnname should be relative and not fixed like select userid or select primaryaddress). Is it possible? is there any keyword that can do that thing? I am new to sql server programming. This is my first post Thanks in advance :) |
|
|
|
|
|
|
|
Please help me with full text search FREETEXT