char

Description

Returns the character equivalent of an integer.

Syntax

char(integer_expr)

Parameters

integer_expr

is any integer (tinyint, smallint, or int) column name, variable, or constant expression between 0 and 255.

Examples

Example 1

select char(42)

- 
* 

Example 2

select xxx = char(65)

xxx
--- 
A

Usage


Reformatting output with char

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Any user can execute char.

See also

Functions ascii, str