title: select max(column) from table (column is varchar)
body: <p>I am going to make a invoices then.. they are going to have a id it is not going to be identity, it is not my idea, this is the idea's my professor's. then he want it so..
  he didn't want i change id to int, he want it was varchar..
  but now i have seen this is as identity.. 
  id =1, next id=2, next=id=3.. 
  but it doesn't mind he told me in the future it is going to be so..</p>
  
  <pre><code>abc000002
  abc000003
  abc000004
  abc000005
  abc000006
  abc000007
  abc000008
  abc000009
  </code></pre>
  
  <p>then for that he doesn't want i change it to int
  how can i get the last? i want it one plus</p>
  
  <p>next i want it was</p>
  
  <pre><code>abc000010
  </code></pre>
  
  <p>how can i do it? i am working on visual basic and visual studio 2008
  i can use  a loop-for, or a query for solve it, but i dont know how to solve it</p>