# Filtering in Result Sets

**URL:** <https://forums.toadworld.com/t/filtering-in-result-sets/46735>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [June 6, 2019, 5:32pm UTC](https://forums.toadworld.com/t/filtering-in-result-sets/46735 "2019-06-06T17:32:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![InfoMan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/infoman/32/322_2.png) [@InfoMan](https://forums.toadworld.com/u/InfoMan)\
**Post date:** [June 6, 2019, 5:32pm UTC](https://forums.toadworld.com/t/filtering-in-result-sets/46735/1 "2019-06-06T17:32:25Z")

</div>

Version 5.0.4.45 (32 bit)

Ran a small query, then filtered the results by clicking on the filter icon for the desired column. The data type of the TIME\_BOX\_SHIPPED column is NUMBER(6). I set the filter to be greater than 230000, but now one of the results does not meet this criteria. How can a record with a value of 82606 be included in the results?

The attached image shows the result set after applying the filter, the table being accessed, and the column data type that was filtered.

It's like the filter is being applied as if the data was text, i.e., text beginning with an '8' would be greater than '230000'?

 ![FilterBug](https://global.discourse-cdn.com/quest/original/2X/e/ea0782ecb0eef8b2f275e195d287cc3eb66dfc4b.jpeg)

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [June 6, 2019, 6:04pm UTC](https://forums.toadworld.com/t/filtering-in-result-sets/46735/2 "2019-06-06T18:04:45Z")

</div>

I am able to reproduce as well. This appears to be a bug. Dev Team, please take note and log.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [June 6, 2019, 7:10pm UTC](https://forums.toadworld.com/t/filtering-in-result-sets/46735/3 "2019-06-06T19:10:02Z")

</div>

Thanks for verifying the issue Gary. I entered QAT-14948 for this. In our next release we have upgraded the grid control so maybe we will get a fix for free...I don't have time to check right now. Sorry

---

<div class="post-metadata">

**Author:** ![chris.ward](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@chris.ward](https://forums.toadworld.com/u/chris.ward)\
**Post date:** [May 20, 2020, 2:03pm UTC](https://forums.toadworld.com/t/filtering-in-result-sets/46735/4 "2020-05-20T14:03:03Z")

</div>

Good day,

Checking to see if this bug has been addressed. I'm running Toad Data Point 5.1.6.206 (64 bit) and am still encountering this issue.

Thanks

---

<div class="post-metadata">

**Author:** ![InfoMan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/infoman/32/322_2.png) [@InfoMan](https://forums.toadworld.com/u/InfoMan)\
**Post date:** [August 19, 2026, 5:57pm UTC](https://forums.toadworld.com/t/filtering-in-result-sets/46735/5 "2026-08-19T17:57:56Z")

</div>

It's August 2026...I'm still seeing this issue in 2026 R1.