Matt, I googled on "sql server noise words" and found this link:
http://arcanecode.com/2008/05/29/creating-and-customizing-noise-words-in-sql-server-2005-full-text-search/ I followed the directions and found the noise lookup file being used by SQL Server 2005 on my computer, and confirmed that "my" is in the list. If you need "my" to be included in your searches, you could remove it from your list. However, if you ever migrate SQL to another server, you'll have to remember to update the noise list on that server. HTH, Carl >Thanks for the tip on using just a single NEAR keyword. In this particular >example (my chemical romance), it still results in no records being >returned. The only thing I can figure is that 'my' is a noise word, and all >searching is ignored once a noise word is hit. > >For the time being, I've merely added 'my' to the list of words that are >parsed out of the search string, and am getting the desired results. Maybe >one day I'll actually have time to figure out what and why. :-) > >Thanks everyone for your help. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
