The second problem can be resolved using substring and padindex e.g.:

select substring(RESIDENTIAL,1,patindex('%,%',RESIDENTIAL )-1) AS Area, substring(RESIDENTIAL,patindex('%,%',RESIDENTIAL)+ 1,4)AS PostalCode