# SQL query '&value'

**URL:** <https://forums.toadworld.com/t/sql-query-value/6133>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 3, 2010, 8:08am UTC](https://forums.toadworld.com/t/sql-query-value/6133 "2010-02-03T08:08:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rickr48](https://avatars.discourse-cdn.com/v4/letter/r/e8c25b/32.png) [@rickr48](https://forums.toadworld.com/u/rickr48)\
**Post date:** [February 3, 2010, 8:08am UTC](https://forums.toadworld.com/t/sql-query-value/6133/1 "2010-02-03T08:08:01Z")

</div>

In TOAD for Oracle I have always been able to type:

select \* from table where table\_field = ‘&value’;

and be prompted for input; however in TOAD for DATA ANALYST this does not work … then same query will not prompt for input ???

---

<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:** [February 3, 2010, 11:07am UTC](https://forums.toadworld.com/t/sql-query-value/6133/2 "2010-02-03T11:07:25Z")

</div>

I added code for this. What version of TDA are you using?

Debbie

---

<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:** [February 3, 2010, 11:12am UTC](https://forums.toadworld.com/t/sql-query-value/6133/3 "2010-02-03T11:12:25Z")

</div>

I just checked. I added this functionality in version 2.6. You can download Beta to test or this version is released at the end of this month.

Debbie