QFQ

# Routine name: QRIGHT
# Parameters: input text, maxlen int 

BEGIN
    DECLARE output TEXT;
    IF maxlen < 1 THEN 
        SET maxlen = 1;
    END IF;
    IF CHAR_LENGTH(input) > maxlen THEN 
        SET output = INSERT(input, maxlen+1, CHAR_LENGTH(input)-maxlen, '...');
    ELSE 
        SET output = input;
    END IF;
    RETURN output;
END

# Routine name: QLEFT
# Parameters: input text, maxlen int

BEGIN
    DECLARE output TEXT;
    IF maxlen < 1 THEN 
        SET maxlen = 1;
    END IF;
    IF CHAR_LENGTH(input) > maxlen THEN 
        SET output = INSERT(input, 1, CHAR_LENGTH(input)-maxlen, '...');
    ELSE 
        SET output = input;
    END IF;
    RETURN output;
END