bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server CHAR() Function

Example

SELECT CHAR(65) AS CodeToCharacter;

Definition and Usage

The CHAR() function returns the character based on the ASCII code.

Syntax

CHAR(
code
)

Parameter Values

ParameterDescription
codeRequired. The ASCII number code to return the character for

Technical Details

Works in:SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Previous

SQL Server ASCII() Function

Next

SQL Server CHARINDEX() Function