noise words in my full-text search condition?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • metaperl

    noise words in my full-text search condition?

    Does anyone see any noise words in this full-text searc query being
    executing on MS SQL 2005?


    SELECT t.Title, t.Organisation, t.ID, t.OnlineStatus
    FROM Abstracts t
    WHERE t.StatusID=3
    AND CONTAINS ( t.ft, '( "acne") OR ("aeroallergen* ") OR
    ("allerg*") OR ("antihistamine *") OR ("atopic") OR ("corticotherap y")
    OR ("cyclospori n") OR ("derm*") OR ("dry skin") OR ("emollient* ") OR
    ("eczema") OR ("histamin*" ) OR ("hives") OR ("immunoglobuli n E") OR
    ("IgE") OR ("pruritis") OR ("psoriasis" ) OR ("rosacea") OR
    ("seborrhea" ) OR ("skin") OR ("stem cell*") OR ("stem mast cell*") OR
    ("utricaria" ) OR ("wart*" )' )
    AND t.DateOnline BETWEEN '11/12/06' AND DATEADD(dd, 8,
    '11/12/06')

Working...