title: sql modifying entries by adding a space
body: <p>I just ran this command  <code>update table set mydata = '$' + mydata where [mydata] not like '$%'
  </code> which worked well, but I forgot to include the space.</p>
  
  <p>so now I have <code>$123</code> and <code>$ 123</code> how can I add the space to all entries?</p>