Returns the character equivalent of an integer.
exp1 - is any integer (tinyint, smallint, or int) column name, variable, or constant
expression between 0 and 255.
� CHAR, a string function, converts a single-byte integer value to a character value (char is usually used as the inverse of ascii.).
� CHAR returns a char data type. If the resulting value is the first byte of a multibyte character, the character may be undefined.
� If char_expr is NULL, returns NULL.
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.
|