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')
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')