title: Trying to search on the last 4 of SSN (SQL)
body: <p>So I have found multiple resources that let me know how to retrieve the last 4 of a SSN.  But I am trying to search the database for matches of the last 4 that I am provided. I am working with Oracle btw.  I've tried a few different things but below is basically what I mean:</p>
  
  <pre><code>SELECT gm.plan_name, tpam.third_prty_admin_name, pm.partcpnt_first_name,
                             pm.partcpnt_last_name, pm.partcpnt_id, gm.grp_id,
                             tpam.third_prty_admin_id,
                             pm.partcpnt_birth_dt,pm.partcpnt_setup_dt
                        FROM gva_s01.partcpnt_mstr pm,
                             gva_s01.grp_mstr gm,
                             gva_s01.third_prty_admin_mstr tpam
                       WHERE gm.cntrct_id = 'CNTRCTID0000'
                         AND gm.third_prty_admin_id = 0
                         AND gm.third_prty_admin_id = tpam.third_prty_admin_id
                         AND gm.cntrct_id = pm.cntrct_id
                         --This is where I can't figure it out
                         AND SUBSTRING(pm.partcpnt_id, -4) = '1234'
  </code></pre>