title: converting varchar to md5
body: <p>I have the following sql code in oracle client 11g.  I would like to convert the "ssno" to md5 hash.  I've read other posts but none of them specifically say where to put the code.  thanks!</p>
  
  <pre><code> SELECT FS_HIRES."rsa",
          FS_HIRES."ssno",
          FS_HIRES."lname",
          FS_HIRES."series",
          FS_HIRES."grade",
          FS_HIRES."pos_title",
          FS_HIRES."ethnicity",
          FS_HIRES."disability",
          FS_HIRES."type_appt",
          FS_HIRES."Perm_Temp",
          FS_HIRES."gender",
          FS_HIRES."age",
          FS_HIRES."age_categories",
          FS_HIRES."los",
          FS_HIRES."date_apnt",
          FS_HIRES."mm_apnt",
          FS_HIRES."yy_apnt",
          FS_HIRES."apnt_noa",
          FS_HIRES."apnt_auth",
          FS_HIRES.L2_DESC,
          FS_HIRES.L3_DESC,
          FS_HIRES.L4_DESC,
          FS_HIRES.L5_DESC,
          FS_HIRES."fy"
     FROM FS_HIRES
  </code></pre>