Remove xml tags from column

I have some xml data stored in database (sqlserver) in following format:eg. email saved as follows:\[code\]<![CDATA[[email protected]]]>\[/code\]My requirement is to fetch the above data without xml tags. Is it possible in sqlserver's query or not?if yes please give your valuable suggestions.I need only "[email protected]".
 
Back
Top