 <p>Depending on how TEXT is defined, the final value might be truncated and then, depending on the client you use to run the query, you may never know about that.</p> <p>Try casting <code>TEXT</code> to a longer <code>VARCHAR</code>, e.g.</p> <pre><code>WITH rquery (category, sequence, sentence) AS (SELECT base.category, base.sequence, CAST( base.text AS VARCHAR(100)) FROM myTable base ... </code></pre> <p>The resulting data type of <code>sentence</code> must be large enough to fit the longest possible concatenation of <code>text</code>s.</p>