473,327 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

simple explanation please

Jay
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
Jul 23 '05 #1
5 1787
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

Jul 23 '05 #2
Jay
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


Jul 23 '05 #3
On Sun, 12 Dec 2004 14:30:39 +1300, Jay wrote:
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


Hi Jay,

You can't use the literal "PREDICATES" in a WHERE clause (or aywhere elses
in a query). Instead, predicate is the name given to all expression that
evaluate to true, false or unknown (as opposed to non-predicate
expressions that evaluate to an integer value, a string, a datetime value,
etc.)

Examples of predicates are
fname LIKE 'Ja%'
ytd_sales > 4095 AND ytd_sales < 12000
AVG(price) > 10.95
EXISTS (insert subquery here)
Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
Jul 23 '05 #4
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



Jul 23 '05 #5
Jay

"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:qj********************************@4ax.com...
On Sun, 12 Dec 2004 14:30:39 +1300, Jay wrote:
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


Hi Jay,

You can't use the literal "PREDICATES" in a WHERE clause (or aywhere elses
in a query). Instead, predicate is the name given to all expression that
evaluate to true, false or unknown (as opposed to non-predicate
expressions that evaluate to an integer value, a string, a datetime value,
etc.)

Examples of predicates are
fname LIKE 'Ja%'
ytd_sales > 4095 AND ytd_sales < 12000
AVG(price) > 10.95
EXISTS (insert subquery here)
Best, Hugo

Ahh many thanks Hugo,
Now I see the light.

Jay
Jul 23 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Gelo Ilzi | last post by:
I'm trying to implement a very simple http server with cgi functionality. The code is simple: import CGIHTTPServer, BaseHTTPServer httpd = BaseHTTPServer.HTTPServer(('',8000),...
11
by: JKop | last post by:
Take the following simple function: unsigned long Plus5Percent(unsigned long input) { return ( input + input / 20 ); } Do yous ever consider the possibly more efficent:
19
by: Bill | last post by:
I have searched through the posts for a question like mine but have only found much more complicated responses. On single record view of a form I have an email address field. I merely want to...
14
by: alwayshouston | last post by:
Hi All! I am working on this very small database and I am confused in the designing a simple form. I only have three tables in the database. First Table: tblExpense Columns: ExpenseID ;...
2
by: Hazzard | last post by:
I just realized that the code I inherited is using all asp.net server controls (ie. webform controls) and when I try to update textboxes on the client side, I lose the new value of the textbox when...
5
by: garyusenet | last post by:
Hi all, Im in the process of writing a simple application. I have a form which has on it five text boxes. I would like to store information that is entered into these text boxes in a small...
14
by: dba_222 | last post by:
Dear experts, Again, sorry to bother you again with such a seemingly dumb question, but I'm having some really mysterious results here. ie. Create procedure the_test As
4
by: sam | last post by:
hI, I am little confused here See i have int wordlen=10; when int s is array s++; whats the meaning of this
25
by: Brian | last post by:
I have a datetimepicker formated for just time, the user selects the time. I want to compare if that time is between midnight and 8 am dtmTime #11:59:59 PM# and dtmTime < #08:00:00 AM# this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.