Hello Everyone,

I'm getting results back in my examples that the function query is actually faster than the XML query.

The following function query returns in a round trip of 9 seconds.

SELECT...

Thanks, Matt!

The XML trick works perfectly, and no functions needed.

Your reference to the XML functionality expanded my SQL world as well.

This is a great tool to keep in my toolbox.

Thanks,...

Matt, I will definitely look at this... Thank you.

Thanks guys,

Your mentioning of this form of statement as a type of update query clarifies things quite easily.

Unfortunately, it pinholes my ability to simply get it to do what I...

Thanks for the replies,

Sorry about the comma not being in there, that was my doing while writing the query into this forum, but it's not that way in the actual...

Thanks for the reply,

Yeah, it's declared above it.

I only wanted to show the basic gist of the query and where the problem lies.

I can't understand why this is not working.

Ryan

Wow!

I was looking at this from a web designer's perspective about quotations, because I tried all combinations of double and single quotations except the three successive single quote wrap, you...

Thank you both for your help! 😀