Split string Text separator between hyphen in sql server :     Select Code From myTable

> In a jod, I have a problem:
> 
> I have result string: 

       Code
     ABCD_12
     EBC_11
     DEEDC_1

> When query data, I want to take the chain on the left "_"
> 
> And Result: 

          Code
         ABCD
         EBC
         DEEDC

Thank you