# Default Decimal places in dynamic table

**URL:** <https://forum.inductiveautomation.com/t/default-decimal-places-in-dynamic-table/9344>\
**Category:** Ignition\
**Created:** [November 14, 2014, 1:52pm UTC](https://forum.inductiveautomation.com/t/default-decimal-places-in-dynamic-table/9344 "2014-11-14T13:52:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [November 14, 2014, 1:52pm UTC](https://forum.inductiveautomation.com/t/default-decimal-places-in-dynamic-table/9344/1 "2014-11-14T13:52:34Z")

</div>

I have an application that queries a couple of different SQL tables and returns the results to an Ignition Table.

Everything returns 2 decimal places by default. I know that you can go to table properties and set each column for 3 decimal places, but the problem is that every time you run the query you may get back different column. How to I change it so that all columns come back 3 decimal places no matter what the columns are??? Yes the data in SQL is 3 decimal places.