Q&A about the site for enthusiasts and power users of the Android operating system
select left(str, charindex('^', str) - 1) from ( select '28 Smith Avenue^MOOROOLBARK VIC 3138^' as str ) as a