SELECT TRIM(" 123 ABC Street") AS "Corrected Address";
SELECT TRIM(" 123 ABC Street...", ".") AS "Corrected Address";