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