a buddy of mine posted the following in the SQL server forum but hasn't gotten any responses. I thought maybe some of the VFP people might have seen this behaviour and could help out. Thanks

>How can I force OPENXML to include all leading and trailing whitespace, and newlines that are in my xml data?
>
>All whitespace and newlines are being removed from my xml data when I use OPENXML to import the data into the database. I am using a specific database table to map the data to datatypes in the database, as in:
>
>Select * from OPENXML(....) WITH myTable
>
>I am aware that there is an attribute called 'xml:space' to force whitespace to remain in the data, but since I am using the database table itself to import I don't have a DTD to add this attribute to.
>
>Is there a way to force OPENXML to include all whitespace and newlines that exist in my xml data?
>
>Thanks,
>---Tom