Thanks for the response. Here are the fields listed..

G.Matter - varchar

GM.C2alias - nvarchar

DM.DOCNUM - float

G.USER_GP_ID - varchar

Does this help?

Thank you!

This is great. Thank you! Exactly what I needed. I do have a follow up questions however.

I have another, but similar table that looks like the following....

Hello. I apologize that my original post was a bit unclear. Based on the table in my original post, I am able to pull the following

2689222701Extra18106

2689322701Extra28106

with this...

Worked like a charm. Thanks for the assistance!

Think I got it. Thanks for all of the help!