If a column is blank the TEXTAGG function excludes it from the output ---------------------------------------------------------------------- Key: TEIID-4192 URL: https://issues.jboss.org/browse/TEIID-4192 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7.5.6_2 Reporter: Debbie Steigner Assignee: Steven Hawkins Fix For: 9.0, 8.12.5, 8.13.5 If a column value is blank, it is excluding it in the result, causing incorrect output. TEXTAGG(FOR Last_Name, First_Name, Middle_initial, Currency_Code DELIMITER '|' QUOTE '"' ) In the above example, if middle name is blank, then it should still show one empty column with "|" delimiter as shown below. Steigner|Debbie||USD But it returns output as excluding middle name since it is blank. Steigner|Debbie|USD