I am running some FOR XML EXPLICIT queries off my database to use in my web
page, but I am getting a "hexadecimal value 0x0B, is an invalid character"
error on some of my queries.

That hex value is the vertical tab. I imported the data I am using into the
database. How do I find these hex values so I can get them out??

Hi

Something like:

SELECT * FROM test where charindex(char(11),col1) > 0

will return all rows where 0x0B is in col1. If you want to search all
character columns try
http://www.users.drew.edu/skass/sql/...Tables.sql.txt

John

"Random" <cipherlad (AT) hotmail (DOT) com> wrote

Perfect! It was just a handful of rows, so I was able to do manual updates
to fix the problem. Thanks!

"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote