issues with exact phrase searching

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm finding that using CONTAINS () and any word or phrase containing
an ' does not work. It seems to split the phrase up instead of doing
an EXACT MATCH search.

example: searching on "computer's technology"

the SQL looks like:
SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank
FROM SCOPE() WHERE CONTAINS ('"computer''s technology"') > 0

this returns files containing "computer" and/or "technology"
not the exact phrase.

I don't believe the issues is my syntax, cause the search works
properly when it's "computer technology", whose SQL looks like:
SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank
FROM SCOPE() WHERE CONTAINS ('"computer technology"') > 0 AND
(Filename LIKE '%_%_%_%.pdf')

Any help? sorry if this is commonly covered, I searched the group and
didn't seem to find anything recent that applied to my issue.
Thanks for your time.

.

Relevant Pages

  • Re: Todays xkcd
    ... Sam Nelson wrote: ... considered, it seems, to have a job a) terribly narrow in scope and ... adequately described by the phrase `knows how to program a computer'. ...
    (uk.misc)
  • Re: Garbage collection problem
    ... >> computation from any live thread. ... the JLS's "can be accessed" in the phrase above. ... there are still references in scope but future behavior depends on user ... beyond the scope of any specification. ...
    (comp.lang.java.programmer)
  • Re: issues with exact phrase searching
    ... FROM SCOPE() WHERE CONTAINS AND (Filename ... with the phrase "computer's technology" in them. ... whose SQL looks like: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Interesting article: In the Beginning: An RDBMS history
    ... it's rather common to use that phrase for foreign keys. ... In a 'standard' that people rely on to make exact decisions, ... I imagine an sql table still couldn't ...
    (comp.databases.theory)
  • Re: SQL statement - chop phrase
    ... I suggest posting your IP address and SA credentials on your public-facing web site. ... That way you can save some poor hacker the trouble of exploiting the SQL Injection hole this leaves in your application. ... Microsoft SQL Server MVP ... typed in phrase: marketing assistant jobs ...
    (microsoft.public.sqlserver.server)