Re: Letters above names in output

["projectproofing"]

Here is my Query (Oracle).

 I have no place to grab a single letter.

         SELECT DISTINCT
                        ind.individual_id,
                        mail_name,
                        first_name,
                        middle_name,
                        last_name,
                        name_suffix,
                        degrees,
                        clinical_specialty service_name,
                        <!---prov.planning_specialty service_name,--->
                        facdept.um_department,
                        fellow_name_flag
          FROM  MS.INDIVIDUAL ind,
                        MS.provider prov,
                        pcd.clinical_faculty clinfac,
                        pcd.view_guide_faculty_department facdept
         where  ind.individual_id = prov.individual_id
                        AND ind.individual_id = clinfac.individual_id
                        AND clinfac.individual_id = facdept.individual_id
                        AND show_on_pcd_flag = 'YES'
                        AND facdept.um_department='#searchphys_department#' 
                        AND clinical_specialty is not null
        UNION
         SELECT DISTINCT
                        ind.individual_id,
                        mail_name,
                        first_name,
                        middle_name,
                        last_name,
                        name_suffix,
                        degrees,
                        prov.planning_specialty service_name,
                        <!---prov.planning_specialty service_name,--->
                        facdept.um_department,
                        fellow_name_flag
          FROM  MS.INDIVIDUAL ind,
                        MS.provider prov,
                        pcd.clinical_faculty clinfac,
                        pcd.view_guide_faculty_department facdept
         where  ind.individual_id = prov.individual_id
                        AND ind.individual_id = clinfac.individual_id
                        AND clinfac.individual_id = facdept.individual_id
                        AND show_on_pcd_flag = 'YES'
                        AND facdept.um_department='#searchphys_department#' 
                        AND clinical_specialty is null