# WHERE clause on READ or FIND statement

**URL:** <https://techcommunity.softwareag.com/t/where-clause-on-read-or-find-statement/74981>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-News-and-General-Topics\
**Created:** [July 7, 2007, 12:01am UTC](https://techcommunity.softwareag.com/t/where-clause-on-read-or-find-statement/74981 "2007-07-07T00:01:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Osman\_Sanchez](https://avatars.discourse-cdn.com/v4/letter/o/ac8455/32.png) [@Osman\_Sanchez](https://techcommunity.softwareag.com/u/Osman_Sanchez)\
**Post date:** [July 7, 2007, 12:01am UTC](https://techcommunity.softwareag.com/t/where-clause-on-read-or-find-statement/74981/1 "2007-07-07T00:01:08Z")

</div>

Hi fellows,  
I would like to know if some one of you can help me to clarify a confusion generated this week in regards of the “where” clause on READ or FIND statement. The things is I always be thinking that the criteria specified into the where clause is solved by Natural, does not it?

Best regards

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [July 7, 2007, 12:03am UTC](https://techcommunity.softwareag.com/t/where-clause-on-read-or-find-statement/74981/2 "2007-07-07T00:03:10Z")

</div>

Yes, indeed. Natural applies the WHERE logic to each record returned from the database.

(For future reference, this type of question belongs in one of the “Natural Basics” forums.)

---

<div class="post-metadata">

**Author:** ![Osman\_Sanchez](https://avatars.discourse-cdn.com/v4/letter/o/ac8455/32.png) [@Osman\_Sanchez](https://techcommunity.softwareag.com/u/Osman_Sanchez)\
**Post date:** [July 7, 2007, 12:14am UTC](https://techcommunity.softwareag.com/t/where-clause-on-read-or-find-statement/74981/3 "2007-07-07T00:14:00Z")

</div>

Ok, thanks a lot…Regards

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:48pm UTC](https://techcommunity.softwareag.com/t/where-clause-on-read-or-find-statement/74981/4 "2021-04-02T14:48:31Z")

</div>