# How do you Capitalize Keywords?

**URL:** <https://forums.toadworld.com/t/how-do-you-capitalize-keywords/6919>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [October 17, 2011, 7:54am UTC](https://forums.toadworld.com/t/how-do-you-capitalize-keywords/6919 "2011-10-17T07:54:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![acharest\_031](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@acharest\_031](https://forums.toadworld.com/u/acharest_031)\
**Post date:** [October 17, 2011, 7:54am UTC](https://forums.toadworld.com/t/how-do-you-capitalize-keywords/6919/1 "2011-10-17T07:54:48Z")

</div>

I am using Toad for Data Analysts version 2.70.0.348. I would like to capitalize the keywords.

Example: select  
then automatically becomes  
SELECT

How can you get this functionality?

---

<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:** [October 17, 2011, 9:24pm UTC](https://forums.toadworld.com/t/how-do-you-capitalize-keywords/6919/2 "2011-10-17T21:24:51Z")

</div>

When you have an editor open, use the Edit | Advanced | Make Uppercase action.

Debbie

 ![Uppercase.png](https://global.discourse-cdn.com/quest/original/2X/2/293885b22a995288ca67d5ff0e49e4bf48188e95.png)

---

<div class="post-metadata">

**Author:** ![acharest\_031](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@acharest\_031](https://forums.toadworld.com/u/acharest_031)\
**Post date:** [October 18, 2011, 5:30am UTC](https://forums.toadworld.com/t/how-do-you-capitalize-keywords/6919/3 "2011-10-18T05:30:44Z")

</div>

In the regular Toad for Oracle, you can configure it so when you type select it automatically converts it to upper case. So, what you are telling me is in the version that I have, it must be done manually.

---

<div class="post-metadata">

**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\
**Post date:** [October 18, 2011, 11:19am UTC](https://forums.toadworld.com/t/how-do-you-capitalize-keywords/6919/4 "2011-10-18T11:19:04Z")

</div>

You can also use Format SQL Action. It is available from Editor toolbar or Main Menu. There are several format options. You can also create your own format rule.

hope that helps.

Alex

---

<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:** [October 18, 2011, 6:04pm UTC](https://forums.toadworld.com/t/how-do-you-capitalize-keywords/6919/5 "2011-10-18T18:04:26Z")

</div>

To automate this define it in your format options as Alexander mentions and run it through the Format SQL Action.

Debbie