Convert Hexadecimal to Binary

Database

Convert Hexadecimal to Binary

Are there any Teradata functions or SQL statements that would convert a hexidecimal value to binary?

e.g. Character string 'E0' would convert to 11100000
1 REPLY
Teradata Employee

Re: Convert Hexadecimal to Binary

SyntaxEditor Code Snippet

sel from_bytes('00'xb||'E0'xb,'base2')  this will give you the result of 11100000.