Inserting a character in the beginning of a string in SQL
<p>I need to change all the 'PostalCode' column strings by setting a character 'A' at the beginning of the string. I've tried this:</p>

<pre><code>UPDATE Customers SET PostalCode = STUFF(PostalCode , 0 , 1 , 'A')
</code></pre>

<p>But nothing... Any ideas?</p>