-- Remove spaces, newline, and tabs from a string CREATE OR REPLACE FUNCTION LTRIM_FULL (aString VARCHAR2) RETURN VARCHAR2 AS newString VARCHAR2(32767); BEGIN newString := Ltrim(aString,(chr(9)||chr(10)||chr(13)||chr(32))); RETURN Trim(newString); END;