# Power Table Formatting

**URL:** <https://forum.inductiveautomation.com/t/power-table-formatting/26511>\
**Category:** Ignition\
**Created:** [July 12, 2019, 2:21pm UTC](https://forum.inductiveautomation.com/t/power-table-formatting/26511 "2019-07-12T14:21:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ranga.Katti](https://avatars.discourse-cdn.com/v4/letter/r/ac8455/32.png) [@Ranga.Katti](https://forum.inductiveautomation.com/u/Ranga.Katti)\
**Post date:** [July 12, 2019, 2:21pm UTC](https://forum.inductiveautomation.com/t/power-table-formatting/26511/1 "2019-07-12T14:21:21Z")

</div>

I am binding a power table data through an sql query. Sql data type is char(50) but actual data length is only 10 char long. If I use TRIM command in sql query, I lose column headings in power table. Is there a different work around to trim data in power table?

Thanks  
Ranga

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [July 12, 2019, 2:58pm UTC](https://forum.inductiveautomation.com/t/power-table-formatting/26511/2 "2019-07-12T14:58:39Z")

</div>

In your query just use AS after the RTRIM

```auto
Select RTRIM(MyFieldName) as MyFieldName

```

---

<div class="post-metadata">

**Author:** ![Ranga.Katti](https://avatars.discourse-cdn.com/v4/letter/r/ac8455/32.png) [@Ranga.Katti](https://forum.inductiveautomation.com/u/Ranga.Katti)\
**Post date:** [July 12, 2019, 2:59pm UTC](https://forum.inductiveautomation.com/t/power-table-formatting/26511/3 "2019-07-12T14:59:24Z")

</div>

Got it. Thank you very much.  
Ranga