SDU Tools: Convert a hexadecimal character string to a character in T-SQL

added by DotNetKicks
10/3/2018 1:56:00 PM

1 Kicks, 1449 Views

On occasions I have to work with binary strings in SQL Server using T-SQL. The literal values are hexadecimal strings. T-SQL doesn't have a simple function to just convert one of these character-pair strings to a character. In our free SDU Tools for developers and DBAs, we added a function HexCharStringToChar to do just this.