Re: text intermedia: what's the purpose of ">0"?

Susan,

CONTAINS is a function that returns a number (i.e. the score, being an indicator for the relevance of the document with respect to the search criterium). If it doesn't find anything the score is 0 (zero), and since you're probably not interested in documents that don't match your question you ask for CONTAINS(xxxxx) > 0.

hth,
Peter

"Susan Lam" <susana73_at_hotmail.com> schreef in bericht news:7186ed56.0210242213.1cd207dd_at_posting.google.com...
> In context intermedia, if I want to do a search I do something like:
> Select name from prospect where
> CONTAINS(resume, 'engineering') > 0;
>
> I don't understand the purpose of ">0" as this query should find all
> the "names" where 'engineering' is appear in resume anyway. So what's
> the purpose of the score?
>
> Thanks,
> ewong
Received on Fri Oct 25 2002 - 08:37:58 CEST