scoosteDusy
New Member
I am looking for a SQL query which can remove all non-xml characters i.e. characters out of \[code\]#x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF] \[/code\]from my rows.I can use http://www.simple-talk.com/sql/t-sql-programming/tsql-regular-expression-workbench/ to create regex replace user defined function. But I am having a hard time writing a regex to locate the non-xml characters. I am using SQL Server 2008.