Posted by: alece January 15, 2015
Login in to Rate this Post:
0
?
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
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