If i understand your question correctly:

Select OriginalString.value('(Addyourrootnodehere/AttributenameHere/@ItemKey)[1]','varchar(max)') as [AlchiLagyo] from dbo.YourTableNameHere

i wud deff love to see your implementation using CHARINDEX AND SUBSTRING though :P