Article:		Controlling Whitespace, Part 1
Subject:		Need to preserve carriage return and line feeds
Date:		2005-08-01 10:12:33
From:		XML?
I am trying to import an XML document in SQL server using OPENXML. I need to retain my carriage returns and line feeds but they seem to get lost. I have tried using xml:space="preserve" but it didn't work. Any has any clue what needs to be done? Thanks.

Previous Message

Next Message

• Need to preserve carriage return and line feeds
  2005-08-01 12:04:14 Bob DuCharme [Reply]
  
  I would try seeking out some people more familiar with SQL Server and/or OpenXML (e.g. a Microsoft mailing list or discussion forum) because it sounds like an implementation issue.

  
  Bob