I've a table with ID & MSG columns. ID is unique identifier & msg is NVARCHAR MAX. abc><poc><tna name="a" value="abc" /><tna name="b" value="def" /><tna name="c" value="xyz" /></poc></abc> I need to find the value "def" from <tna> tag whose Name = "b" based on the ID [where clause]. This is a huge table. Need to consider the performance as well.