# sql select ... in equivalent axapta

**URL:** <https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255>\
**Category:** Developer Forum\
**Created:** [January 29, 2013, 10:31am UTC](https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255 "2013-01-29T10:31:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![metinemre](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@metinemre](https://www.dynamicsuser.net/u/metinemre)\
**Post date:** [January 29, 2013, 10:31am UTC](https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255/1 "2013-01-29T10:31:06Z")

</div>

Hi All,

I want to write sql select … in equivalent axapta like that:

select CustTable Where CustTable.CustGroup in (“CST”,“AVM”,“BYZ”)

How can I write that in Axapta except using or clause with three ==.

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [January 29, 2013, 10:48am UTC](https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255/2 "2013-01-29T10:48:55Z")

</div>

Use II (or) condition

while select custTable

where (custTable.custGroup == ‘CST’ || custTable.custGroup == ‘AVM’ || custTable.custGroup == ‘BYZ’)

{}

---

<div class="post-metadata">

**Author:** ![metinemre](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@metinemre](https://www.dynamicsuser.net/u/metinemre)\
**Post date:** [January 29, 2013, 11:39am UTC](https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255/3 "2013-01-29T11:39:47Z")

</div>

I just said “How can I write that in Axapta except using or clause with three ==.” [;)]

---

<div class="post-metadata">

**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\
**Post date:** [January 29, 2013, 12:07pm UTC](https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255/4 "2013-01-29T12:07:27Z")

</div>

AX does not support operator IN, so you’ll really end with a query like this. But you can get more flexibility if you use the Query framework - then you can iterate through a collection of values add ranges individually for each value.

If you use AX2012, you can also fill values to a temporary table in database (TempDB) and use normal join. Definitely use this approach if you have lots of values.

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [January 29, 2013, 12:12pm UTC](https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255/5 "2013-01-29T12:12:49Z")

</div>

That was missed 🙂

you can use ‘like’ keyword also but OR need to be used as well

while select custTable

where custTable.CustGroup like ‘20’ ||

custTable.CustGroup like ‘30’

{}

---

<div class="post-metadata">

**Author:** ![metinemre](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@metinemre](https://www.dynamicsuser.net/u/metinemre)\
**Post date:** [January 29, 2013, 12:40pm UTC](https://www.dynamicsuser.net/t/sql-select-in-equivalent-axapta/43255/6 "2013-01-29T12:40:26Z")

</div>

When they throwed away Oracle at Axapta 2012, I thought (In fact I’m not sure if Oracle supports in) I thought they made that decision just support more MS-SQL commands but it seem decision just about marketing…