title: Generate sequence of numbers prefix with an alphabet
body: <p>I would like to generate a sequence of numbers as "A0000"(ie.. an alphabet followed by 4numbers not randomly generated numbers).</p>
  
  <p>I have gone through this <a href="http://www.codeproject.com/Articles/491733/Auto-generated-sequence-number-in-SQL-Server" rel="nofollow">article</a> which is done with Sql Server similarly how can I achieve it in VB.Net.</p>
  
  <p>Here is the code for SQL Server:</p>
  
  <pre><code>create function CustomerNumber (@id int) 
  returns char(5) 
  as 
  begin 
  return 'C' + right('0000' + convert(varchar(10), @id), 4) 
  end
  </code></pre>
  
  <p>Any suggestions are welcome.</p>