CHR() or CHAR()

Scalar. Returns the characters responding to one or more Unicode code points.

Syntax

CHR( expression [, ...] ) CHAR( expression [, ...] )

Parameters
expression	A Unicode code point. An invalid code point, 0, or NULL returns NULL.

Data Types
Return	expression
String	Integer

The following example inserts a tab into the second column of OutStream.

INSERT INTO OutStream 
SELECT InStream.Column1, CHR(9) 
FROM InStream;