I have the following code in the select block of my query which picks out rows from a table and outputs them in XML:

```
select ...
       ...
,substring(
        (
            Select RC_1.Master_Code  AS [TopographyTDR]
            From apex.Histo_Result_Coding as RC_1
            Where RC_1.Histo_Report = Histo_Result_Coding.Histo_Report
            ORDER BY RC_1.Histo_report
            For XML auto
        ), 1, 1000) [TDRCodes]
       ...

```

and this gives an output similar to that shown below:

```
<RC_1 TopographyTDR="T77100"/><RC_1 TopographyTDR="T77100"/>
<RC_1 TopographyTDR="T01000"/><RC_1 TopographyTDR="T01000"/>
<RC_1 TopographyTDR="EGFR "/> <RC_1 TopographyTDR="GHER2"/>
<RC_1 TopographyTDR="T04020"/><RC_1 TopographyTDR="T04020"/>
<RC_1 TopographyTDR="T77100"/><RC_1 TopographyTDR="T77100"/>

```

This is the correct data, but I need the tag to be 'TopographyTDR' without the RC\_1. i.e. the data should look like:

```
 <TopographyTDR="T77100"/><TopographyTDR="T77100"/>
 <TopographyTDR="T01000"/><TopographyTDR="T01000"/>
 <TopographyTDR="EGFR "/> <TopographyTDR="GHER2"/>
 <TopographyTDR="T04020"/><TopographyTDR="T04020"/>
 <TopographyTDR="T77100"/><TopographyTDR="T77100"/>

```

Is there a simple way to do this? i.e. to avoid having the table name appear in the XML tag text?

Thanks in advance.