InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 28 Aug 2008 08:02:46 GMT20http://www.teradata.com/teradataforum/Topic10708-22-1.aspxI'm trying to create a flat file, with a delim of ;, and without spaces between each column. The query I'm using below doesn't work in Fast Export due to it running on a single amp. When I remove the trim criteria, it runs without issue. What would cause the single amp error to occur when running this sql below? Thanks in advance for your help!select substring(trim(col1) from 1 for 10) || ';', substring(trim(col2) from 1 for 10)||';', substring(trim(col3) from 1 for 1)||';', substring(trim(col4) from 1 for 5)||';' FROM where col1 in (criteria);Tue, 26 Feb 2008 14:13:51 GMTbknightly