CHAR Function - SQL

Overview

The CHAR function in returns the character corresponding to the given ASCII code value. It is useful for converting numeric ASCII codes back into their character equivalents.

Example:

SELECT CHAR(65)

Syntax:

SELECT CHAR(ascii_code)

ascii_code is the integer representing the ASCII code value that you want to convert to its corresponding character.

Example: Hard-coded value

In this example, we are returning the CHAR character for the ascii code input of 65, the output is A.