dan.sql

Stuff((SELECT ' ' + B.reference 
       FROM   tagnet_appointmentspn_partnerorderadditionalreferences B 
       WHERE  B.partnerprimaryorderid = headers.partnerprimaryorderid 
              AND B.referencetype = 'CR' 
              AND LEFT(B.reference, 1) NOT IN ( '0', '1', '2', '3', 
                                                '4', '5', '6', '7', 
                                                '8', '9' ) 
       FOR xml path('')), 1, 1, '')          AS 'PARTNER NAME', 

roland.sql

(SELECT addref2.reference from tagnet_appointmentspn_partnerorderadditionalreferences as addref2 where addref2.referencetype in ('cr') 
				and left(addref2.partnerprimaryorderid,1) not in ('0', 
                     '1', 
                     '2', 
                     '3', 
                     '4', 
                     '5', 
                     '6', 
                     '7', 
                     '8', 
                     '9')) as 'PARTNER NAME',