Hi Crispin

I used the following:

Select client_id, cl_fname, cl_lname FROM clients AS Client for XML AUTO, ELEMENTS

This gives me:

<Client>

<client_id>1</client_id>

<cl_fname>koos</cl_fname>

<cl_lname>Viljoen</cl_lname>

</Client>

This is ok, but i am actually looking for:

<Client client_id="1">

<cl_fname>koos</cl_fname>

<cl_lname>Viljoen</cl_lname>

</Client>

How would I have to change the query if at all it is possible

Cheers

ruan