# Table Word Wrap

**URL:** <https://forum.inductiveautomation.com/t/table-word-wrap/6938>\
**Category:** Ignition\
**Created:** [July 26, 2013, 5:13am UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938 "2013-07-26T05:13:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![allenr8](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\
**Post date:** [July 26, 2013, 5:13am UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938/1 "2013-07-26T05:13:50Z")

</div>

Is it possible to get my text to wrap in a table? I have a SQL query and I’m pulling in four columns and one of them is a note column that can get quite lengthy.

I have seen that you can put an in front of text to get it to wrap, but how would I inject that into a plain SQL query?

The query is below:

SELECT TStamp, Note, WhoID AS ‘User’,(Select Facility From Facilities Where ID = SiteID) AS ‘Site’  
FROM Comments  
Order by TStamp DESC

Any help is appreciated!

Thanks

---

<div class="post-metadata">

**Author:** ![aidamcg](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\
**Post date:** [July 26, 2013, 7:01am UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938/2 "2013-07-26T07:01:37Z")

</div>

Hi

I did this once and I think I just put before the column name in the query so for you it would be SELECT TStamp, ‘’+ Note, WhoID AS ‘User’,(Select Facility From Facilities Where ID = SiteID) AS ‘Site’  
FROM Comments  
Order by TStamp DESC

The problem is that the row height won’t change so you will have to make them large enough to accommodate all your note text.

You could look at using the comments panel which will wrap and adjust row heigth

---

<div class="post-metadata">

**Author:** ![allenr8](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\
**Post date:** [July 26, 2013, 4:52pm UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938/3 "2013-07-26T16:52:46Z")

</div>

I am using the comments panel in a by area basis, but have modified it slightly to keep track of comments by area.

I am only doing this on an overall page to show all the comments with their associated site next to them.

That worked though - thanks for the help. Now how do I get my table to keep the column widths I want…

---

<div class="post-metadata">

**Author:** ![aidamcg](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\
**Post date:** [July 29, 2013, 6:44am UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938/4 "2013-07-29T06:44:44Z")

</div>

Hi

To keep column widths go into preview mode in the designer and set the column widths to how you want them on your table. Then go out of preview mode and go to table customizer and hit ok. The table should keep the column widths that you set from preview mode

Aidan

---

<div class="post-metadata">

**Author:** ![allenr8](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\
**Post date:** [August 1, 2013, 8:03pm UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938/5 "2013-08-01T20:03:08Z")

</div>

Thanks - I was just missing the last step!

---

<div class="post-metadata">

**Author:** ![allenr8](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\
**Post date:** [August 1, 2013, 8:35pm UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938/6 "2013-08-01T20:35:55Z")

</div>

Thanks - I was just missing the last step!