# Clean way to do conditional statement in SQL?

**URL:** https://forum.kx.com/t/clean-way-to-do-conditional-statement-in-sql/12307
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [December 8, 2021, 4:48pm UTC](https://forum.kx.com/t/clean-way-to-do-conditional-statement-in-sql/12307 "2021-12-08T16:48:00Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![ekallivrousis1](https://avatars.discourse-cdn.com/v4/letter/e/e95f7d/32.png) [@ekallivrousis1](https://forum.kx.com/u/ekallivrousis1)
#### Post date: [December 8, 2021, 4:48pm UTC](https://forum.kx.com/t/clean-way-to-do-conditional-statement-in-sql/12307/1 "2021-12-08T16:48:00Z")

</div>

I was wondering what the best way to do conditional update in q? I know i can do the below but wondering if theres a shorter/cleaner way.

&nbsp;

&nbsp;

&nbsp;

t:flip `a`b!(1 2;01b) update c:{$[x;`true;`false]} each b from t

&nbsp;

&nbsp;

&nbsp;

---

<div class="post-metadata">

### Author: ![vkennedy1](https://avatars.discourse-cdn.com/v4/letter/v/6bbea6/32.png) [@vkennedy1](https://forum.kx.com/u/vkennedy1)
#### Post date: [December 8, 2021, 5:00pm UTC](https://forum.kx.com/t/clean-way-to-do-conditional-statement-in-sql/12307/2 "2021-12-08T17:00:00Z")

</div>

update c:?[b;`true;`false] from t

---

<div class="post-metadata">

### Author: ![ekallivrousis1](https://avatars.discourse-cdn.com/v4/letter/e/e95f7d/32.png) [@ekallivrousis1](https://forum.kx.com/u/ekallivrousis1)
#### Post date: [December 8, 2021, 5:01pm UTC](https://forum.kx.com/t/clean-way-to-do-conditional-statement-in-sql/12307/3 "2021-12-08T17:01:00Z")

</div>

exactly what i was looking for! thank you

---

<div class="post-metadata">

### Author: ![soheir1](https://avatars.discourse-cdn.com/v4/letter/s/d6d6ee/32.png) [@soheir1](https://forum.kx.com/u/soheir1)
#### Post date: [December 8, 2021, 5:05pm UTC](https://forum.kx.com/t/clean-way-to-do-conditional-statement-in-sql/12307/4 "2021-12-08T17:05:00Z")

</div>

Hi @ekallivrousis, try using a vector conditional -&nbsp;https://code.kx.com/q/ref/vector-conditional/

update c:?[b;`true;`false] from t

b = vector of booleans being passed in  
&nbsp;