String functions and operators Actuate SQL supports the following string functions and operators: Case conversion functions: UPPER, LOWER Concatenation operator: || Length function: CHAR_LENGTH LIKE operator Substring functions: LEFT, RIGHT, SUBSTRING Trimming functions: LTRIM, RTRIM, TRIM Search function: POSITION