a ver, intenta con esto y dime si es lo que necesitas
Código PHP:
(SELECT upper(NAMES.FName)+' '+ upper(NAMES.LName)as FULLNAME,
FROM NAMES INNER JOIN UDF ON NAMES.ID = UDF.NameID
where UDF.UdfText = '110532')
Union
(SELECT UDF.UdfText
FROM NAMES INNER JOIN UDF ON NAMES.ID = UDF.NameID
where UDF.UdfText = '110532'
AND UDF.UdfNum in (1,3,6,7,8,9) )