eg. Column Name: ActivityDefinitionXML
Data in the column: ...<Reason for Suspension>This is a test</Reason for Suspension>...
So for example I will need to retrieve "This is a test" text from in between the xml braces. I am familiar with the substring function however that is only use for fixed position indexing of characters within the column. Suppose if it is not a fixed indexed column. Is there any SQL out there that does it?
Any help would be greatly appreciated.