How to make sql 2005 full text search index short words

Would anyone have a suggestion on how to make SQL 2005 FTS index words like C# or C++? I know I could remove C (c) from noise words but FTS still ingores # and ++.

I have a text field that contains people's resumes (blobs) and inability to find C#, C++ et al is quite a show stopper.

TIA
lcdataAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
FT Search considers # as a word breaker.  However see this article:
http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

<quote>
Generally, the words broken at index time are stored in the catalogs exactly as broken by the word breakers. However, there are some exceptions. For example:

c# is indexed as c (if c is not in your noise word list, see more on noise word lists later), but C# is indexed as C# (in SQL 2005 and SQL 2000 running on Win2003 regardless if C or c is in your noise word list). It is not only C# that is stored as C#, but any capital letter followed by #. Conversely, c++ ( and any other lower-cased letter followed by a ++) is indexed as c (regardless of whether c is in your noise word list).
</quote>

If that does not work for you will have to get creative.
0
 
lcdataAuthor Commented:
Just to add to this: I also have an xml field, FT indexed as well - same problem.

If there's no solution with 2005, would anyone know if 2008 offers more flexibility (been looking on MS site, but their text is like IBM's - no one understands anything). How about alternative solutions? Something that well integrates with SQL 2005?

TIA
0
 
lcdataAuthor Commented:
thank you for your time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.