title: Generate unique string in sql server 2012
body: <p>I have a table </p>
  
  <pre><code>CREATE TABLE #Agency 
   (
    AgencyID int PRimary KEY IDENTITY(1,1),
    AgencyName varchar(100), 
    AgencyCode varchar(50)
    )
  </code></pre>
  
  <p>I want to generate a unique agency code while inserting into the table...Agency code should consists of only Alphabets ..no numbers or special characters</p>
  
  <p>Thank you</p>