SQL Kiwi (1/27/2012)
That's the same as the code I posted (just without the /text() optimization).
I don't understand what this /text() optimization does. On my system it makes the example query 4 times faster. Why is that? Does it performs better for any sql data type?