Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

TSQL Challenge 40 - Convert string representation of numeric values fr

By Jacob Sebastian,

TSQL Challenge 40 - Convert string representation of numeric values from binary to hexadecimal format.

This challenge involves converting numeric values from binary format to hexadecimal format. Your job is to process all the input rows from the source table and produce hexadecimal representation of the binary values.

Total article views: 1613 | Views in the last 30 days: 3
Related Articles

SQL Server: Converting binary data to a hexadecimal string

Problem I have a requirement to convert the binary data inside a table column or variable to a he...


Convert binary SID to string

Converts a binary SID to string format.


Multidimensional database internal representation.

Multidimensional database internal representation.


Convert integers/numbers into binary format - viceversa

This functions are used to convert integers/numbers into binary format and viceversa.


TSQL Challenge 51 - Convert long Binary strings to Decimal strings

This challenge invites you to write a query that converts binary values into decimal format.


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones