title: Adding characters in values in an existing column
body: <p>I need to add characters to values in a column.  For example:</p>
  
  <pre><code>Price column
  22.99
  12.95
  10.35
  </code></pre>
  
  <p>For my query output, I need this column to show as </p>
  
  <pre><code>Price column
  Price is 22.99
  Price is 12.95
  Price is 10.35
  </code></pre>
  
  <p>I already used this to convert these values to char as I think I have to do this to insert characters in this column...</p>
  
  <pre><code>CONVERT (char(12), price) AS price
  </code></pre>
  
  <p>I just can't figure out how I can write the command to add "Price is" in every row :(</p>
  
  <p>Please help, thank you!</p>