Bram Gadeyne created TEIID-3315: ----------------------------------- Summary: problem with function TRIM Key: TEIID-3315 URL: https://issues.jboss.org/browse/TEIID-3315 Project: Teiid Issue Type: Bug Affects Versions: 8.9.1 Reporter: Bram Gadeyne Assignee: Steven Hawkins I have a database that contains some columns with multiple values separated with comma . So I'm trying to use a combination of case, substring and trim to split these values into multiple colums. The following statement part does not work: case when pos2 = 0 then trim(substring(Description, pos1+1)) end as bed TEIID31100 Parsing error: Encountered "+1)[*])[*] end as" at line 3, column 68. If I add ' ' FROM to the trim statement it does work and returns a correct result. working statement: case when pos2 = 0 then trim(' ' FROM substring(Description, pos1+1)) end as bed -- This message was sent by Atlassian JIRA (v6.3.11#6341)