Reverse comma separated column values in SQL Server <p>I have following column which contains values separated by comma. How do I convert it to a result set which gives following out put in SQL Server?</p> <pre><code>DECLARE @TBL AS TABLE (COLUMN1 NVARCHAR(100)) INSERT INTO @TBL SELECT 'AUD,BRL,GBP,CAD,CLP' SELECT COLUMN1 FROM @TBL COLUMN1 ------- AUD,BRL,GBP,CAD,CLP </code></pre> <p>Result I wanted:</p> <pre><code>COLUMN1 ------- AUD BRL GBP CAD CLP </code></pre>