# Dropdown bind to SQL query, but allow no selection

**URL:** <https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498>\
**Category:** Ignition\
**Created:** [July 12, 2019, 12:10am UTC](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498 "2019-07-12T00:10:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [July 12, 2019, 12:10am UTC](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498/1 "2019-07-12T00:10:12Z")

</div>

Using 7.9.10, I have a dropdown list bound to SQL query. This works fine. What if I want to deselect and have nothing selected? How can this be accomplished? Right now, the only available choices are what’s returned from the query, adding to the SQL table with a no solution value isn’t an option.

Any ideas?

---

<div class="post-metadata">

**Author:** ![nick.schuetz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nick.schuetz/32/6160_2.png) [@nick.schuetz](https://forum.inductiveautomation.com/u/nick.schuetz)\
**Post date:** [July 12, 2019, 2:14am UTC](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498/2 "2019-07-12T02:14:11Z")

</div>

You could add a value to the query results without adding it into the database using something like

```auto
SELECT '-1', '<No Selection>'
UNION
<existing query>

```

The types from this added select need to match your current select.

Or you can add a button that sets the dropdowns selected value to -1.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [July 13, 2019, 1:03pm UTC](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498/3 "2019-07-13T13:03:34Z")

</div>

Thanks Nick!