# Formatter alias identifier case option

**URL:** <https://forums.toadworld.com/t/formatter-alias-identifier-case-option/58018>\
**Category:** Toad for Oracle - Beta\
**Created:** [August 23, 2023, 11:59am UTC](https://forums.toadworld.com/t/formatter-alias-identifier-case-option/58018 "2023-08-23T11:59:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dolo](https://avatars.discourse-cdn.com/v4/letter/d/9e8a1a/32.png) [@dolo](https://forums.toadworld.com/u/dolo)\
**Post date:** [August 23, 2023, 11:59am UTC](https://forums.toadworld.com/t/formatter-alias-identifier-case-option/58018/1 "2023-08-23T11:59:06Z")

</div>

Is there a way to use formatter to set lowercase aliases but keep other identifiers uppercase?  
For example:

```auto
select mt.COL1
from MY_TABLE mt
where mt.COL2 like '%'
  and mt.COL3 = 1;

```

instead

```auto
select MT.COL1
from MY_TABLE MT
where MT.COL2 like '%'
  and MT.COL3 = 1;

```

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [August 25, 2023, 1:36pm UTC](https://forums.toadworld.com/t/formatter-alias-identifier-case-option/58018/2 "2023-08-25T13:36:55Z")

</div>

That is not part of the current options, sorry. It looks a useful feature though.

Andre