Extracting string after and before a character '-' or '<' using Sql Query
The LEFT and RIGHT functions are helpful for this kind of parsing. They only return X number of characters from that side of a VARCHAR like so:
SELECT RTRIM(LEFT(AccountMasterUDF.UDF_WorkLocation_6, CHARINDEX('-', AccountMasterUDF.UDF_WorkLocation_6) - 1)) AS Column1,  
LEFT(LTRIM(RIGHT(AccountMasterUDF.UDF_WorkLocation_6, LEN(AccountMasterUDF.UDF_WorkLocation_6) - CHARINDEX('-', AccountMasterUDF.UDF_WorkLocation_6))), CHARINDEX('&lt;',LTRIM(RIGHT(AccountMasterUDF.UDF_WorkLocation_6, LEN(AccountMasterUDF.UDF_WorkLocation_6) - CHARINDEX('-', AccountMasterUDF.UDF_WorkLocation_6)))) - 1) AS Column2

As you can see, combined with CHARINDEX to locate the - in both cases, and LTRIM and RTRIM to remove any unneeded whitespace.
In the second case you need to apply the LEFT function on top of your output from the RIGHT function to do one more search and removal of the ending .
Also here's a more formatted version of the stacked functions above that I find more readable if you prefer:
SELECT 
    RTRIM
    (
        LEFT
        (
            AccountMasterUDF.UDF_WorkLocation_6, 
            CHARINDEX('-', AccountMasterUDF.UDF_WorkLocation_6) - 1
        )
    ) AS Column1,  
    LEFT
    (
        LTRIM
        (
            RIGHT
            (
                AccountMasterUDF.UDF_WorkLocation_6, 
                LEN(AccountMasterUDF.UDF_WorkLocation_6) - CHARINDEX('-', AccountMasterUDF.UDF_WorkLocation_6)
            )
        ), 
        CHARINDEX
        (
            '&lt;',
            LTRIM
            (
                RIGHT
                (
                    AccountMasterUDF.UDF_WorkLocation_6, 
                    LEN(AccountMasterUDF.UDF_WorkLocation_6) - CHARINDEX('-', AccountMasterUDF.UDF_WorkLocation_6)
                )
            )
        ) - 1
    ) AS Column2