<p>What is the XPath expression that I would use to get the string following 'HarryPotter:' for each book.</p>

<p>ie. Given this XML:</p>

<pre><code>&lt;bookstore&gt;
&lt;book&gt;
  HarryPotter:Chamber of Secrets 
&lt;/book&gt;
&lt;book&gt;
  HarryPotter:Prisoners in Azkabahn 
&lt;/book&gt;
&lt;/bookstore&gt;
</code></pre>

<p>I would get back:</p>

<pre><code>Chamber of Secrets
Prisoners in Azkabahn 
</code></pre>

<p>I have tried something like this:</p>

<pre><code>/bookstore/book/text()[substring-after(. , 'HarryPotter:')] 
</code></pre>

<p>I think my syntax is incorrect...</p>

In your XML you've got no space between Harry Potter but in your XQuery you've got a space.  Just make it match and presto, you'll get data back...
```
```
Dim xml = <bookstore>
                  <book>HarryPotter:Chamber of Secrets</book>
                  <book>HarryPotter:Prisoners in Azkabahn</book>
                  <book>MyDummyBook:Dummy Title</book>
              </bookstore>

    Dim xdoc As New Xml.XmlDocument
    xdoc.LoadXml(xml.ToString)

    Dim Nodes = xdoc.SelectNodes("/bookstore/book/text()[substring-after(., 'HarryPotter:')]")

    Dim Iter = Nodes.GetEnumerator()
    While Iter.MoveNext
        With DirectCast(Iter.Current, Xml.XmlNode).Value
            Console.WriteLine(.Substring(.IndexOf(":") + 1))
        End With
    End While
```
```