It works! Thanks so much for sticking with me and solving this issue.

The complete string is:

SELECT REPLACE(CAST(layerXMLData AS VARCHAR(MAX)), '/>', 'groupid=''' + CAST(groupid AS VARCHAR(5))+ ''' />')

FROM [LOCAL_TEST].[dbo].[testtable10]

Are...

Dwain,

It looks like my last post #1405712 was posted less than a minute after your new suggestion, so that post was actually a reply to your first comment, not...

Dwain.c,

Thank you for your input and advice. This is indeed how I would like the final output to look. However, I need the groupId to populate automatically based...

Sean,

Thanks for the pointers on correct posting. Apologies for my rookie mistake.

I have been using and reviewing your how-to-post document and I've learned a lot just from reading it. I...