Thanks for your help everyone. Did some further work last night and came up with a solution for my needs.
SELECT a.ur_number, b.ur_number, c.name_last, c.name_first
FROM SYS_CLI_Client a
INNER JOIN SYS_CLI_Client b ON (SUBSTRING(a.ur_number, 1, LEN(a.ur_number) - 1)=b.ur_number)
INNER JOIN SYS_GEN_Person c on (b.person_id = c.id)
WHERE a.ur_number LIKE ('%[A-Z]')