Options

Find a hexadecimal character

cwioskowcwioskow Posts: 2
edited January 24, 2014 6:00AM in SQL Search Previous Versions
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.
· Share on Twitter

Comments

  • Options
    Adam WAdam W Posts: 111 Silver 3
    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
    · Share on Twitter
Sign In or Register to comment.