SQLite CHAR() Function

The SQLite CHAR() function interprets each passed argument as an integer and returns a string consisting of the characters given by the code values of those integers.

Syntax

CHAR(X1, X2, ..., XN)

Parameters

Return Value

Returns a string consisting of the characters given by the code values of those integers.

Example 1:

The example below shows the usage of CHAR() function.

SELECT CHAR(72,69,76,76,79);
Result: 'HELLO'

SELECT CHAR('72',69,'76',76,79);
Result: 'HELLO'

SELECT CHAR('72.8',69,'76.3',76,79);
Result: 'HELLO'

SELECT CHAR(65,66,67);
Result: 'ABC'

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to get the string containing characters given by the code values specified by columns x1, x2 and x3.

SELECT *, CHAR(x1, x2, x3) AS CHAR_String FROM Sample;

The query will produce the following result: