selecting information from table : Hello i am new to sql server and used to work on normal sql , I have an issue 

In table i have for example 591|15-MA TEST 
i want to retrieve 15-MA TEST  i tried to mix substring , charindex , left with no use , Can any one help me 