Q&A for community managers, administrators, and moderators
select left(str, charindex('^', str) - 1), reverse(str) from ( select '28 Smith Avenue^MOOROOLBARK VIC 3138^' as str ) as a