CHAR - A string function that converts an int ASCII code to a character.

Syntax - CHAR ( integer_expression )

Arguments - integer_expression

Is an integer from 0 through 255. NULL is returned if the integer expression is not in this range.

Return Types - char(1)

Remarks

CHAR can be used to insert control characters into character strings. The table shows some commonly used control characters.

Control character Value
Tab CHAR(9)
Line feed CHAR(10)
Carriage return CHAR(13)