Power Table Formatting

Ignition
1

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

2

In your query just use AS after the RTRIM

Select RTRIM(MyFieldName) as MyFieldName
3

Got it. Thank you very much.
Ranga