3 Replies Latest reply on Oct 4, 2010 7:49 AM by Arnej6511

    Query for Multiple Rows as XML 'NULL' question


      There are two fields in the database.


      Foo = null (real null)

      Foo1 = '' (blank string)


      In my return xml the nodes are as follows:






      Why is it that if there is a null in the database, that it puts the string null, and then when there is a blank string, the node is empty?


      How can I get the null value to act like the blank value?