<div>
Are you sure that spaces are in the variable?<br />
Where are you openinig your file? Maybe in a &quot;visual&quot; editor (just like Internet Explorer)? If so, you may see spaces where there are only tabs, or maybe nothing...<br />
Some viewers/editors apply formatting to XML files. <br />
Please ensure you are not in this case...<br />
<br />
<br />
Regards.
</div>


Are you sure that spaces are in the variable?
Where are you openinig your file? Maybe in a "visual" editor (just like Internet Explorer)? If so, you may see spaces where there are only tabs, or maybe nothing...
Some viewers/editors apply formatting to XML files.
Please ensure you are not in this case...


Regards.

<div>
I'm not looking at it in a viewer.<br />
<br />
I'm getting a response stream and sending it straight to SQL Server.
</div>


I'm not looking at it in a viewer.

I'm getting a response stream and sending it straight to SQL Server.

<div>
That was it...the DataLength
</div>


<div>
<div class="content wysiwyg-content">
What is the best way for me to get a true &quot;Length&quot; on an XML field that was inserted using a HttpWebResponse chunked response and a read buffer like this in VB<br />
streamRead.Read(readBuff, 0, 5120)<br />
<br />
<br />
This is my select<br />
SELECT LEN(CAST(XmlDoc AS VARCHAR(MAX))) xmlDoc FROM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[dbo].[VOIPXMLTransactionL<wbr />og]<br />
<br />
But it seems to be ignoring spaces?
</div>
</div>


What is the best way for me to get a true "Length" on an XML field that was inserted using a HttpWebResponse chunked response and a read buffer like this in VB
streamRead.Read(readBuff, 0, 5120)


This is my select
SELECT LEN(CAST(XmlDoc AS VARCHAR(MAX))) xmlDoc FROM	[dbo].[VOIPXMLTransactionLog]

But it seems to be ignoring spaces?

SQL Server Select LEN on XML

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.