Skip to main content
The 2024 Developer Survey results are live! See the results
1 vote

Convert hex string representation to hex number in SQL Server T-SQL

You can just convert it to binary(2) with style 2, and then concat it with 0x0000 (the binary value, not a string) SELECT 0x0000 + CONVERT(binary(2), '16A1', 2); db<>fiddle
Charlieface's user avatar
  • 13.7k
1 vote
Accepted

Convert hex string representation to hex number in SQL Server T-SQL

I'm not aware of a function to specifically do that but it's easy enough to accomplish with the following: SELECT '0x' + RIGHT('00000000' + '16A1', 8) AS SomeHexString Example dbfiddle.uk As in ...
J.D.'s user avatar
  • 38.3k
1 vote
Accepted

Covert from literal HEX value to INT MariaDB

If you need to convert hexadecimal representation to decimal one then you must use CONV() function. SELECT CONV('ff', 16, 10); | CONV('ff', 16, 10) | | :----------------- | | 255 | ...
Akina's user avatar
  • 20.1k
1 vote

64 bit hexadecimal AS Date in SQL

This value is encrypted by QlikView to prevent you from tampering with the value. Some fields in the generated XML file i.e. "LastUsed", are encrypted for security reasons, thus cannot be ...
David Browne - Microsoft's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible