# TOAD's Formatting Case Conversion

**URL:** <https://forums.toadworld.com/t/toads-formatting-case-conversion/48943>\
**Category:** Idea Pond\
**Created:** [February 5, 2020, 2:48pm UTC](https://forums.toadworld.com/t/toads-formatting-case-conversion/48943 "2020-02-05T14:48:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chandru\_ks](https://avatars.discourse-cdn.com/v4/letter/c/bb73d2/32.png) [@chandru\_ks](https://forums.toadworld.com/u/chandru_ks)\
**Post date:** [February 5, 2020, 2:48pm UTC](https://forums.toadworld.com/t/toads-formatting-case-conversion/48943/1 "2020-02-05T14:48:25Z")

</div>

It will be awesome if TOAD's Formatting for case conversion has more options. I have a style of writing SQL where KEYWORDS, TABLENAMES, COLUMNNAMES are ALL CAPS and Table Aliases are in lower case. I found Toad Formatter very useful, but if you can expand the identifiers to table aliases, column aliases and so on it will be very helpful.

Example SQL  
SELECT  
a.COL\_NAME1,  
a.COL\_NAME2,  
a.COL\_NAME3,  
b.COL\_NAME1,  
b.COL\_NAME2  
FROM  
TABLE1 a,  
TABLE2 b  
WHERE  
a.JOINKEY1 = b.JOINKEY1  
AND a.JOINKEY2 = b.JOINKEY2
