Hi gljjr

I understand the basic syntax of how the EXPLICIT mode works, I just want to know if I need to go change my tables to look like a Universal...

Hi Eamon

thanx for the help, but I sort of figured out a way to do it with EXPLICIT.

Thanx anyway

Ruan

That could work, I will then have to use a lot of XPath expression which is not neccesarily a bad thing.

If I could however perhaps get something like this:

<ROOT>

<Client client_id="1">

<cl_fname>koos</cl_fname>

<cl_lname>viljoen</cl_lname>

</client>

</ROOT>

would...

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...