title: Generating the same random string in SQL for a set of rows
body: <p>I am trying to 'obfuscate' data in a SQL database for the purposes of testing. I have a single field in a single table where I want the values to be replaced with a random string - however the same string has to have the same value. So for example:</p>
  
  <pre><code>Cat
  Dog
  Cat
  Fish
  Monkey
  </code></pre>
  
  <p>Would have to replaced with</p>
  
  <pre><code>YuW -- same
  JiK
  YuW -- same
  IPoQ
  KYiLwY
  </code></pre>
  
  <p>I don't want this to be reversible (so no ROT13, etc..)</p>
  
  <p>EDIT: i need for it to remain the same length as well. This database will be used for performance testing purposes, and I want realistic string sizes to be used.</p>