XQuery Lab 41 - Another string parsing example using XQuery

We have seen a number of string parsing/manipulating examples using XQuery and FOR XML in the previous sessions of XQuery Labs . This session presents yet another string parsing example using XML data type methods. Here is the string value that we need...

XQuery Lab 40 - Extracting words matching a pattern from a varchar column

We saw a number of string manipulation examples using FOR XML and XML Data Type methods. Here is yet another string parsing requirement that we will solve using the XML Data type methods. In this post, we will see how to extract words from strings stored...

XQuery Lab 19 - How to parse a delimited string?

  XML Data Type functions can be used to perform a number of string operations. This post explains how to parse a delimited string using the XML approach. The XML approach helps you to avoid the WHILE-LOOP that you might need with most other approaches...