They may work. I was actually starting to do that after my last reply. Thanks.

Well I took out the part I was trying because it wasn't working correctly. What I posted is the original code.

Alright thanks to everyone that provided some help I was able to get it with a few tricks with the suggestions here.

Here is my final query:

The query I used was the following

SELECT c.value('(ParameterValue[Name ="TO"]/Value/Text())[1]', 'nvarchar(max)') AS Emailreceipt, c.value('(ParameterValue[Name ="CC"]/Value/Text())[1]', 'nvarchar(max)') AS EmailCopy,
c.value('(ParameterValue[Name ="RenderFormat"]/Value/Text())[1]', 'nchar(3)') AS RenderFormat, c.value('(ParameterValue[Name ="AKDunsNumber"]/Value/Text())[1]', 'int') AS AKDunsNumber

Drew,

I did try it your way and I'm getting an error...

Holy crap thank you so much. I was able to get it to work correctly. I need to narrow the search down. Thank you so much!!

That was close. I will need to see if I can tweak it a little to make it 100% like I need. Thanks.

Sadly I'm trying to tweak it...

Yes I do understand that the sample data only had one value. for AKDunsNumber. There are a total of 38 records I need to go through and a total of...

Alright... Here is some same data:

<ParameterValues><ParameterValue><Name>prmExpandState</Name><Value>Collapse</Value></ParameterValue><ParameterValue><Name>AKDunsNumber</Name><Value>146159</Value></ParameterValue></ParameterValues>

From this I'm extracting the following:

AKDunsNumber
146159
119529
241828
280644
39156
296293
177030
119529
39156
296590

I forgot to mention Med_Rec_Nbr is a nvarchar. I had the cast in my original just trying to do a little more efficient. Thanks for all the helpful replies I...

Thanks man that did the trick. I just wasn't seeing what I was doing wrong.