Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2001
    Location
    Washington, DC
    Posts
    24

    Unanswered: Overriding multi-form compound word searches w/ FTS?

    Hey gang. So MS Index Server automatically searches for all forms of a hyphenated compound---doing a CONTAINS search for "teen-age" brings back "teen-age", "teen age", and "teenage" in the results. Is there a way to override this behavior, so if I wish to see only results containing the hyphenated form of "teen-age", I can? Thanks for any insight.

  2. #2
    Join Date
    Feb 2002
    Location
    St. Louis, MO
    Posts
    2

    Search for hyphenated text

    Did you try a search for a wild card type search where the hyphen is replaced by the wildcard '_' as in:

    Select * from myTable where myField like '%teen_age%'

    Jeff

  3. #3
    Join Date
    Feb 2002
    Location
    Seattle, WA
    Posts
    3
    You might also want to try:

    select * from MyTable where contains(*, ' "teen*" ')

    Thanks,
    --andrew

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •