I have a "TEXT" column called NewsItem that contains an XML snippet that looks like this:
Column Result Data:
<summary-body><headline><main-hed>How Can I Get New Gadgets for Vista Sidebar?</main-hed></headline><p><highlight type="BOLD">Walt Mossberg answers</highlight> questions about getting new Gadgets for Vista Sidebar, the type of keyboard on the BlackBerry Curve, and whether the iPhone will allow third-party programs to be installed.</p></summary-body>
I want to LIMIT the INNER CONTENT of this data to 50 characters, meaning everything inside <main-hed> should amount to 50 characters max.
What is a good way to accomplish such advanced string manipulation with sql??