Usage for char

There are additional considerations for using char.

char returns a char datatype. If the resulting value is the first byte of a multibyte character, the character may be undefined.
If char_expr is NULL, returns NULL.

See also Transact-SQL Users Guide.

Reformatting Output With char
You can use concatenation and char values to add tabs or carriage returns to reformat output. char(10) converts to a return; char(9) converts to a tab.

Parent topic: char

Related reference

ascii

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com