Browse by Tags
All Tags »
String-manipulation-using-xml (
RSS)
We have seen a number of string manipulation examples using XML. Here is yet another example that uses FOR XML to convert a VARBINARY value to VARCHAR. Some one asked me this question in one of the forums. The story is like this. The OP did a data migration...
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...
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...
We have seen a number of posts on various string operations using XQuery functions and FOR XML operator. This post explains how to match a delimited string against another delimited string. I wanted to share a piece of code that I wrote to help a member...
One of the two common string operations that we do often are 'parsing' delimited strings and 'generating' delimited strings. This post explains how to generate a delimited string using FOR XML. I like XML and many of you might have noted...
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...