WHERE (Condition)

WHERE (Condition)

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

WHERE (Condition)

WHERE

States a condition.

Syntax

WHERE expression

Parameters

expression

A logic expression using conditional and Boolean operators.

Comments

WHERE states the conditions that restrict processing in the main command to only certain members of the set specification, contingent on a value within each of the (related) records being considered.

Of all the available (related) records in the record-containing objects, only those records for which the condition is logically true become members of the set.

Example

list all Employees where LastName = Smith and FirstName = J?

The preceding command lists only those employees whose last name is Smith and whose first name starts with the letter J.

 

See Also

About Boolean Expressions

About Conditional Expressions

ADD

CHANGE

COMPUTE

DELETE

DELETE FROM

INSERT

LIST

REPORT FROM

SELECT

UPDATE

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

pt_BRPortuguese