title: Extracting 8 alphanumeric character from a string value
body: <p>I am trying to find an alphanumeric 8 character from a string value. For example : If my string is <code>//SC202646 ABCBUB22XXX</code> , then it should extract <code>ABCBUB22</code> or any value which satisfies the condition that it is of 8 alphanumeric character length.
  I am executing it through sql and want to extract it using regex function</p>