CHAR(number) Where number is a numeric value between 1-255 (Extended ASCII character codes).; And, the syntax of the SUBSTITUTE() function is: SUBSTITUTE(text, old_text, new_text, [instance_num ...