[ https://issues.jboss.org/browse/TEIIDDES-2389?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2389 at 3/10/15 11:16 AM: ------------------------------------------------------------------ Basically add a "NO TRIM" check-box to the TEXT TABLE options dialog. This was added in Teiid 8.8, so only need to commit to master for 9.1 release see: https://docs.jboss.org/author/display/TEIID/FROM+Clause * NO TRIM specified on the TEXTTABLE, it will affect *all column and header values*. *If NO TRIM is specified on a column*, then the fixed or unqualified text value not be trimmed of leading and trailing white space. {code} TEXTTABLE(expression [SELECTOR string] COLUMNS <COLUMN>, ... [NO ROW DELIMITER | ROW DELIMITER char] [DELIMITER char] [(QUOTE|ESCAPE) char] [HEADER [integer]] [SKIP integer] [NO TRIM]) AS name {code} Where <COLUMN> {code} COLUMN := name (FOR ORDINALITY | datatype [WIDTH integer [NO TRIM]] [SELECTOR string integer]) {code} was (Author: blafond): Basically add a "NO TRIM" check-box to the TEXT TABLE options dialog. This was added in Teiid 8.8, so only need to commit to master for 9.1 release -- This message was sent by Atlassian JIRA (v6.3.11#6341)