title: SQL - generate alphanumeric string with specific format
body: <p>I need to find out how to generate an alphanumeric string that follows the format like in the answer for <a href="https://stackoverflow.com/questions/1324063/generating-random-strings-with-t-sql">this question</a> which I'm currently using, except it has to be in the following format:</p>
  
  <p>Vowel + consonant + vowel + consonant + 4-digit number</p>
  
  <p>For example ABAB1111 or IJUZ9236.</p>
  
  <p>Thanks for any suggestion.</p>