While I don't have a SS2000 test bed, I'm fairly certain XMl was in 2000. The code I posted works on 2005 for certain.

Short of SS 2008 my favorite is a table valued function... I've used this quite a bit and it never fails me, except for the < character which is ...