SQLxD Part 9 — WHERE and LIKE operator

This is the ninth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation

As the last predicate we implement LIKE operator. It is not that simple so the implementation is pretty long. By the way, did you know that there is LIKE operator available in C#? You just need to use some internal VB implementation.

However, SQLxD implementation looks as follows:

Since there are multiple edge cases with escaping characters, it is important to test the code. In the next part we will unit test all operators.