Renaming elements???

Hi

I'm trying to generate an xml file from a database using sql, but I want the
element names to be something other than the field names in the table
eg: the sql statement    select Field1, Field2, Field3 from Table 
generates elements 
Field1
Field2
Field3

I want to call them
Somethingelse1
Somethingelse2
Somethingelse3


I've tried select Field1 ans Somethingelse1 but it doesn't like it

Is there a quick way to do this or do I have to treat the generated xml as a
string and replace etc etc etc 



Thanks anyone who can help!

Kath Prescott  
Tel: 01242 573869
Mobile: 07984 717299

> The NSPCC FULL STOP Campaign is entering a new phase.  Its latest TV
> advertising urges the public to do something if they suspect a child is
> being abused.  This is one of a range of activities to communicate a
> simple message:  Together we can stop child abuse.  FULL STOP.
> For more information on the FULL STOP Campaign and the work of the NSPCC,
> visit www.nspcc.org.uk
> If you have concerns about the welfare of a child, please call the NSPCC
> National Child Protection Helpline on Freephone 0808 800 5000.  This is a
> 24 hour, seven days a week service and calls are free.
>

Received on Saturday, 20 April 2002 18:38:57 UTC