Extracting substring between two characters OR Delimeters using TSQL,SQLServer 2008

sample values in that Username column:-

1)  <Name=test>

2)  <Name=testKing>

3)  <Name=King>

Sql Query

select SUBSTRING(loginname,CHARINDEX('=',Username )+1,CHARINDEX('>',Username )-CHARINDEX('=',Username )-1)

Result 

  1. test

  2. testKing

  3. King