# Find / Replace behavior

**URL:** <https://forums.toadworld.com/t/find-replace-behavior/30872>\
**Category:** Toad for SQL Server\
**Created:** [September 7, 2014, 11:10am UTC](https://forums.toadworld.com/t/find-replace-behavior/30872 "2014-09-07T11:10:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![benik9](https://avatars.discourse-cdn.com/v4/letter/b/ce73a5/32.png) [@benik9](https://forums.toadworld.com/u/benik9)\
**Post date:** [September 7, 2014, 11:10am UTC](https://forums.toadworld.com/t/find-replace-behavior/30872/1 "2014-09-07T11:10:39Z")

</div>

Is there a keyboard only way of doing find / replace?

Like in SSMS, just do Ctrl+F to find what I want and go to the next with F3, while still looking at the code.

In toad, the visual window adds nothing but forces me to pay attention to that window. Especially the navigation has to be done using a mouse. This creates distraction.

---

<div class="post-metadata">

**Author:** ![benik9](https://avatars.discourse-cdn.com/v4/letter/b/ce73a5/32.png) [@benik9](https://forums.toadworld.com/u/benik9)\
**Post date:** [September 7, 2014, 2:41pm UTC](https://forums.toadworld.com/t/find-replace-behavior/30872/2 "2014-09-07T14:41:59Z")

</div>

Also, is there a way to get 0 or 1 instead of “Unchecked” or “Checked” in copy/paste or excel export?

---

<div class="post-metadata">

**Author:** ![fernando.olmos2013](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/fernando.olmos2013/32/188_2.png) [@fernando.olmos2013](https://forums.toadworld.com/u/fernando.olmos2013)\
**Post date:** [September 10, 2014, 6:18pm UTC](https://forums.toadworld.com/t/find-replace-behavior/30872/3 "2014-09-10T18:18:36Z")

</div>

[mention:9d167c2b340a4726b1525d23d60d4a3f:e9ed411860ed4f2ba0265705b8793d05] Your last post is also what I would like to see happening. I have to write an UPDATE script just to set a BIT datatype to NULL, when all I want is to be able to paste a NULL directly into the cell. Is this possible?
