"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."

Umair Feroze

Rate me:

5.00/5 (2 votes)

5 Jan 2011CPOL

30.2K

To resolve the invalid chracter from FOR XML PATH clause

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

5 Jan 2011#realJSOP

You can also enclose your column name in brackets, like so: [Create Date]

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Umair Feroze

Software Developer (Senior) Shams Software Services

Pakistan

I have been working as a Senior Software Analyst in Shams Software Services and during this I have been working in Sql Server and C# .Net