Character Functions Returning Character Values The character functions that return character values are: CHR CONCAT LOWER and UPPER LPAD LTRIM NCHR NLSSORT REPLACE RPAD RTRIM SOUNDEX SUBSTR, SUBSTRB, SUBSTR4 TRIM