When I perform a query and use the "For XML Auto" at the end of my query
to generate the results it looks something like this..

<Customers CustomerID="ALFKI" ContactName="Maria Anders">
<Orders OrderID="10643"/>
<Orders OrderID="10692"/>

Is there any way that to make the attributes be surrounded by single quotes
instead of double quotes? i.e. I want the result to look like this..

<Customers CustomerID='ALFKI' ContactName='Maria Anders'>
<Orders OrderID='10643'/>
<Orders OrderID='10692'/>

Thanks in advance