Re: Contains

Tech-Archive recommends: Speed Up your PC by fixing your registry

Rick wrote on Wed, 5 Jul 2006 11:14:23 -0500:

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.

The E is ignored as it's in the noise word file.

Using wildcards return no data:

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

*JOHN is not valid syntax - a * may only be used at the end of terms. There
is no "suffix" searching in FTS.

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.

Does anyone know the best way to handle this?

You can empty the noise word file for your catalog (leave just a space in
the file), and then run a full population.

Dan


.

Relevant Pages

  • Contains
    ... query returns different results than expected. ... select * from tablename where contains ... JOHN E SMITH and JOHN L SMITH. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Contains
    ... alphabet string from the noise word file repopulated the full text ... JOHN E SMITH and JOHN L SMITH. ... The E is ignored as it's in the noise word file. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Contains
    ... alphabet string from the noise word file repopulated the full text indexes, ... JOHN E SMITH and JOHN L SMITH. ... The E is ignored as it's in the noise word file. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Mail merge
    ... Assuming it's the same as in the PC environment, I'd have thought you could control the print paramters by setting up the paper source definitions in your mailmerge main document - before executing the merge. ... John, Smith, Jan, 10 ... > The merge involves a 2 page letter and pages for coupons. ...
    (microsoft.public.mac.office.excel)
  • Re: "Please tell me your name?"
    ... Smith being the family name and John the given name (= Christian ... They also often include grandparents' surnames as well: John Smith Jones Cooper Danks. ... I know someone who told me that he and his two brothers have three different surnames because they made different choices. ...
    (alt.usage.english)