One of my output columns contain xml data .My requirement is I want to write a query which will give an output of a particular portion of the xml data .
Say within the xmldata I have <me>wiqwn</me>.I want only this part as the output.
Can u suggest how should be the query for that be ?
But what i actually wanted is not select '<me>wiqwn</me>' because i dont know the "wiqwn" and this will be variable every time .
I have the fixed opening and closing tag i want the contents within it as output .