Recently we had an audit done by an outside agency that used the last 4 digits of the SS# to identify the
patient charges they chose to audit. We have a need to take a look at several of those charts, but the
only identifying data we now have is the last 4 SS# digits. How can I retrieve the patients with just this
information?
The following query should provide you with what you need. Just replace 1234 in the last line with the
digits you want to search. Don't neglect the single quotes around the number:
SELECT
lastname,
firstname,
id,
socsec
FROM
sos.patients
WHERE
RIGHT(socsec,4) = '1234'
If you have a list of numbers you would like to do in a single shot, you can modify it as follows:
SELECT
lastname,
firstname,
id,
socsec,
RIGHT(socsec,4) as "last4"
FROM
sos.patients
WHERE
last4 IN ('1234','5678','2468','4321')
or, for a complete list of patients, sorted by the last four digits:
SELECT
RIGHT(socsec,4) as "last4",
lastname,
firstname,
id,
socsec
FROM
sos.patients
ORDER BY
last4