title: SQLBase: is there a lpad function?
body: <p>I am using SQLBase and I have to complete a column with zeros.</p>
  <p>This example works in PostgreSQL. I need to do the same in SQLBase but there isn't a function like <code>lpad</code>.</p>
  <pre><code>SELECT lpad(last_name, 10, '0')
  FROM persons;
  </code></pre>
  <p>If <code>last_name</code> is <em>Douglas</em>, the result is:</p>
  <pre><code>000Douglas
  </code></pre>
  <p>Is there a way to define a function that can do the same as lpad?</p>