For XML Auto and Nulls 1

[aspivey]

If I execute a 'Select * from XYZ for XML Auto', the result set doesn't contain any fields that had nulls. I need those fields also even if they are null value. Can someone provide any help?

 

[tlbroadbent]

List the columns in the Select statement and use the IsNull function to convert nulls to empty strings.

Select
isnull(colA,'') As ColA,
isnull(colB,'') As ColB,
isnull(colC,'') As ColC,
isnull(colD,'') As ColD
From XYZ Fro XML Auto Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[aspivey]

Thanks Terry,

Spot on with that advice.

Archie