SQL Server String Function: CHAR

In the previous post, we discussed how to get the ASCII code from a text string, and now we'll find out how to get the text string if the ASCII code is known.

We can use the CHAR() function to get characters from a specific ASCII code.

Example: We will try to find characters with ASCII codes 60, 64, 74, and 85.

SELECT CHAR(60) AS CharOfASCII;

SELECT CHAR(64) AS CharOfASCII;

SELECT CHAR(74) AS CharOfASCII;

SELECT CHAR(85) AS CharOfASCII;