Hi Jay
It is an expression which is also in the BOL index, but the topic "Search
Conditions" is probably the best example for predicates
< predicate > ::=
{ expression { = | < > | ! = | > | > = | ! > | < | < = | ! < }
expression
| string_expression [ NOT ] LIKE string_expression
[ ESCAPE 'escape_character' ]
| expression [ NOT ] BETWEEN expression AND expression
| expression IS [ NOT ] NULL
| CONTAINS
( { column | * } , '< contains_search_condition >' )
| FREETEXT ( { column | * } , 'freetext_string' )
| expression [ NOT ] IN ( subquery | expression [ ,...n ] )
| expression { = | < > | ! = | > | > = | ! > | < | < = | ! < }
{ ALL | SOME | ANY} ( subquery )
| EXISTS ( subquery )
John
"Jay" <nospam@*here.com> wrote in message
news:zf*******************@news.xtra.co.nz...
Thanks... I should have said that I found it in BOL but came away none the
wiser.
OK so it's T/F or Unknown.... but what is it?
Jay
"John Bell" <jb************@hotmail.com> wrote in message
news:41**********************@news.easynet.co.uk.. . Hi
You need to check the index!
Predicate
Is an expression that evaluates to TRUE, FALSE, or UNKNOWN. Predicates
are used in the search condition of WHERE clauses and HAVING clauses, and
the join conditions of FROM clauses.
John
"Jay" <nospam@*here.com> wrote in message
news:6b*******************@news.xtra.co.nz... PREDICATES
Used as a clause.
A. What does PREDICATES mean?
B. What does it mean when used in a where clause?
I checked BOL (Glossary) but get no explanation there.
Thanks
Jay