hex values somewhere in database... help! - 12-21-2004 , 05:25 PM
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??
Re: hex values somewhere in database... help! - 12-22-2004 , 06:01 AM
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
"Random" <cipherlad (AT) hotmail (DOT) com> wrote
Re: hex values somewhere in database... help! - 12-22-2004 , 10:13 AM
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