title: LPAD in SQL Server 2008
body: <p>I can't see a function like <code>LPAD</code> in SQL Server 2008. For example how can I convert the following queries into T-SQL?</p>
  <pre><code>select  LPAD(MY_VALUE,2,' ')) VALUE
  FROM MY_TABLE
  </code></pre>