Find a hexadecimal character

A free Management Studio add-in to search for SQL in your databases

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott

Find a hexadecimal character

Postby cwioskow » Mon Jan 13, 2014 10:49 pm

What is the proper syntax to use in SQL Search to locate a specific hexadecimal character (in this case, 0x0B)?

I tried CHAR(0x0B), but that doesn't return anything, and I know that the character exists somewhere in at least one of the tables in a specific database, as it is causing an issue with our ERP software.
cwioskow
 
Posts: 1
Joined: Mon Jan 13, 2014 10:34 pm
Location: Dearborn, MI

Postby Adam » Fri Jan 24, 2014 12:00 pm

Hi,

We don't currently support searching for hexadecimal characters. However, if this is something you'd like us to consider, please suggest this on our UserVoice forum so we can see how popular this would be.

In the meantime we have raised this as an enhancement request.

Thanks for your question.

Adam
Adam
 
Posts: 24
Joined: Tue May 27, 2008 1:40 pm
Location: Cambridge, England


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 0 guests