Related to FULL TEXT SEARCH - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Related to FULL TEXT SEARCH

Author

Topic

yaman
Posting Yak Master

213 Posts

Posted - 2009-06-25 : 03:24:01

sir ,

I have a query used to find c# word in Primary skill column .

SELECT ConsultantID, PriamrySkill
FROM dbo.tbl_Consultant
WHERE CONTAINS(PrimarySkill,'c#')

Run successfully when i am pass :- c#
But when i am pass :- C# ( capital C# ) then my query not find any record .

Pls help me out sir .

Yaman

nathans
Aged Yak Warrior

938 Posts

Posted - 2009-06-25 : 03:44:14

Please see: http://www.eggheadcafe.com/conversation.aspx?messageid=29440438&threadid=29440435

nathans
Aged Yak Warrior

938 Posts

Posted - 2009-06-25 : 03:45:18

and even more detail here: http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

yaman
Posting Yak Master

213 Posts

Posted - 2009-06-25 : 05:43:44

quote:
Originally posted by nathans

and even more detail here: http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Thanks alot sir ,
I read both sites ........

This is not enough sir ......................

Yaman

nathans
Aged Yak Warrior

938 Posts

Posted - 2009-06-25 : 12:49:42

This link seemed to describe and resolve your exact issue. Did you try its recommendations?

http://www.eggheadcafe.com/conversation.aspx?messageid=29440438&threadid=29440435

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources