Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL Server CHAR() Function

Concept visual

SQL Server CHAR() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the character based on the number code 65:

SELECT CHAR(65) AS CodeToCharacter;

Definition and Usage

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

Syntax

Char(

code )

Parameter Values

Parameter

Description code

Required. 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

SQL Server CHAR() Function

Concept visual

SQL Server CHAR() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the character based on the number code 65:

SELECT CHAR(65) AS CodeToCharacter;

Definition and Usage

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

Syntax

Char(

code )

Parameter Values

Parameter

Description code

Required. 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

SQL Server CHAR() Function

SQL Server CHAR() Function

Example

Definition and Usage

Syntax

Char(

Parameter Values

Parameter

Description code

Technical Details

Works in:

Previous

Next

SQL Server CHAR() Function

SQL Server CHAR() Function

Example

Definition and Usage

Syntax

Char(

Parameter Values

Parameter

Description code

Technical Details

Works in:

Previous

Next