Thanks Jeff.  It is not an integer field - int was short for interactions.

Actually, the query was fine.  It was the data I joined it to was the problem.  After correcting my error and using the specific data set I wanted to see,...

Thanks Jeff.  This appears to be exactly what I am looking for.  How would I replace the string with a field name called int_ID now?  I don't know what to...

Thanks to Jonathan AC Roberts and Lowell.  I'm going to try and see if I can get this on one line or join the CTE to my existing data.  For...

I was hoping to have it as 1 select statement as I have to join it to other data.  I do appreciate what you showed me however, as it breaks...

Please disregard my post #3674055.  It was a reply to a post no longer there 🙁

That returns urn:ADL:CC_LB_SF_EN_D_C_[LB_LS_TCD]_[LB_LS_CotCF]_28_1 and I need ADL:CC_LB_SF_EN_D_C_[LB_LS_TCD]_[LB_LS_CotCF]_28 returned.  Everything between the urn: and the last _

Also, I should have been clearer.  I have hundreds, if not a thousand of these...

Thanks Jacob!  I am banging my head on my desk now!  To be soooo close and have the singles quotes be the error!

I fixed my SQL and I...

Thank you soooooooooo much Gail!

The output is perfect.  I will compare to what I did wrong and then recreate my original query in the replicated database I have...