SQL concatenations
<p>Say I have</p>

<pre><code>SELECT [id] as [Customer's ID] FROM [users];
</code></pre>

<p>How how can I put a string in front of [id] value?</p>

<p>I've tried </p>

<pre><code>SELECT + "CTMR-ID-" + [id] as [Customer's ID] 
</code></pre>

<p>but it don't work.</p>