Give Space in SQL String
<p>I have SQL string stored in table column, and it contains character like this 
<code>201603030040000</code></p>

<p>So i want to have a result like this </p>

<p><code>2016 0303 0004 0000</code></p>

<p>I already tried with stuff, </p>

<p><code>SET @output = (SELECT Stuff(Voucherid, 5, 0, ' ') + ';' FROM #tmpBus FOR XML PATH(''))</code></p>

<p>But unfortunately it give me an result like this</p>

<p><code>2016 030300040000</code></p>

<p>is there a workaround for this issue ?</p>