A recent blog of Roland Wenzlofsky introduced us to the CHAR2HEXINT function to extract coding table numbers for tokens. If you found this a little off the scope of practical problems you have to deal with on a daily basis, let me tell you that exactly these functions just helped us a lot in solving

Read More

If you ever had the needed to find out the ASCII-Code of a character, you will know that no function in Teradata SQL exists to solve this problem. Here is a query workaround that solves this issue. What below SQL statement does is the following: The CHAR2HEXINT Teradata SQL function returns a hexadecimal value; we

Read More