Thanks very much! It works great.

Could you post your syntax?

I tried:

set @presp = @pFile.value('(/*:Enroll/../Context/@SubmitterUserId)[1]', 'varchar(30)')

and get a null result.

Thanks!!!

Thanks very much! I tweaked it a bit and was able to insert my XML to a table as a binary and then select it back as XML.

This is...

you are AWESOME!!!!!!!!!!!!!!!!!!!! Thank you. This worked perfectly AND I learned something! Thanks!!!

Very sorry. I grabbed a sample I had manually altered. Here is a straight file.

Thanks,

Maureen

Thanks. I didn't scroll down far enough before to see the attachment option.

Here is the XML as an attachment.

You bring up a good point regarding 350 values to 350 variables.

The project is, a user can fill in a PDF and save it to the database. The PDF...

Thanks for the info. Let me see if I can make this more precise.

I have an XML file that I convert to a table that looks like this:

FieldName ...