Obtaining null values using the FOR XML clause

[sigven]

Hi.

I have a slight problem retrieving xml-data from
Sql server 2000 using the FOR XML clause. My wish is that all tuples in each table will all get the same number of attributes in xml. However, if there are som null values in some column in the database,
the xml won't produce an attribute with value "null".

More precisely: How do I obtain xml-attributes with
"null"-values from the server?

-sig-

programmer from Norway