Jeff - Thanks I'll bear this in mind.

I've now hit a minor hiccup.

I'm using the FOR XML route as this seems to be 99% ideal for wehat I need. but when I specify a special character, like '>', in the query, it doesn't reproduce the character, it simply just has '&gt' instead.

Same goes for '>' too (ie. &lt)

Any way round this?

Dave