WHERE (Condition)
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
WHERE (Condition)
0 out of 5 stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
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
Updated
ByJason Lee
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