Contains query results

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm appologize for posting this again, but I was told about posting aliases,
seeing our company is an MSDN subscriber I set up the posting alias and I am
reposting:

We have a table with Full Text Index on a name column, running the
following query returns different results than expected.

select * from tablename where contains(membername, '"JOHN E SMITH"')

Data returned is: JOHN E SMITH and JOHN L SMITH.

Using wildcards return both names:

select * from tablename where contains(membername, '"*JOHN E SMITH* "')

That data that is expected would be to return only JOHN E SMITH.

It seems the noise word file has the entire alphabet in it by single letter.
This seems to be an issue with a middle initial in the name.

I was given a response in my previous post, to remove the noise words in the
noise file leaving a space in the file and repopulating the full text
indexes.
I've tried that route and still recieved the same results:

What is best way to handle this?

Thanks,
Rick




.

Relevant Pages

  • Re: Contains query results
    ... alias and I am reposting: ... JOHN E SMITH and JOHN L SMITH. ... It seems the noise word file has the entire alphabet in it by single ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Lottery Strategies
    ... RGL Gremlin aka "John Griffin" wrote.. ... You alone have destroyed this Newsgroup with the most repetitive, ... A sampling of the posting history of giant bimbo Sherry ... "I said 'the only way,' bimbos. ...
    (rec.gambling.lottery)
  • Re: Christ only 5% of posts here make it past my kill filters
    ... you may not recall John Curtis who posted at the same time as ... Chris Raum, White Dragon (also posting as ~WD), and T. R. Ellis. ... John Curtis was the moving force behind my getting together with him, ... Michael Ejercito ...
    (soc.men)
  • Re: Ping Don Moody
    ... Posting libelous material ... Why ask John to do your dirty work? ... subject and they had better bugger off somewhere quiet and rethink whether they are suited to study the subject. ... When he was finished he told me to bugger off and earn enough money to pay a garage, and never again lift the bonnet and fiddle with what was under it. ...
    (soc.genealogy.britain)
  • Re: Someone Just E-mailed Me The Next Chapter
    ... I did not respond with "utmost ferocity" because I thought we were friends ... You accomplished, with one dumb post, what John and Gerry have not been able ... I bet the bitch wasn't counting on me posting MY private ...
    (rec.gambling.lottery)