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]')