# Schema Compare - Inclusion Options - AND NOT

**URL:** <https://forums.toadworld.com/t/schema-compare-inclusion-options-and-not/34844>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 14, 2016, 10:45am UTC](https://forums.toadworld.com/t/schema-compare-inclusion-options-and-not/34844 "2016-01-14T10:45:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jimkd1yv](https://avatars.discourse-cdn.com/v4/letter/j/f17d59/32.png) [@jimkd1yv](https://forums.toadworld.com/u/jimkd1yv)\
**Post date:** [January 14, 2016, 10:45am UTC](https://forums.toadworld.com/t/schema-compare-inclusion-options-and-not/34844/1 "2016-01-14T10:45:26Z")

</div>

Toad for Oracle Xpert 12.6 with DBADMIN add-in module.

Under Schema Compare Inclusion Options, I know how to use a semicolon to separate logical OR conditions. Now I want exclude a few criteria by switching it to NOT AND NOT AND NOT … I tried checking the NOT box and using the semicolon, but that does not work.

Suggestions?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 14, 2016, 12:04pm UTC](https://forums.toadworld.com/t/schema-compare-inclusion-options-and-not/34844/2 "2016-01-14T12:04:25Z")

</div>

Check “Only Extract Object Names Like”

Check “Not Like”

Enter multiple values in the edit box like this: THIS;THAT;THE\_OTHER

When I turn on spool SQL, I see this in one of the SQL statements:

AND queue\_table NOT LIKE ‘THIS’

AND queue\_table NOT LIKE ‘THAT’

AND queue\_table NOT LIKE ‘THE\_OTHER’

---

<div class="post-metadata">

**Author:** ![jimkd1yv](https://avatars.discourse-cdn.com/v4/letter/j/f17d59/32.png) [@jimkd1yv](https://forums.toadworld.com/u/jimkd1yv)\
**Post date:** [January 14, 2016, 1:17pm UTC](https://forums.toadworld.com/t/schema-compare-inclusion-options-and-not/34844/3 "2016-01-14T13:17:43Z")

</div>

Thanks John, that worked. I actually tried that before, but I was expecting it to do something additional that it wasn’t intended to do.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 14, 2016, 1:20pm UTC](https://forums.toadworld.com/t/schema-compare-inclusion-options-and-not/34844/4 "2016-01-14T13:20:09Z")

</div>

You’re welcome. Let me know if there’s something that you need it to do that it won’t.