Thanks ever so MUCH. I really appreciate your help.

SELECT @xml.query('

<Workers>

{

for $x in //d1p1:Worker

return

<Worker>

<EmployeeID>{$x/d1p1:Worker_Reference/d1p1:ID[@d1p1:type="Employee_ID"]/text()}</EmployeeID>

<FullName>?? unknown ??</FullName>

</Worker>

}

</Workers>

')

If I have my data in a file and I want to run the above code against it, how do I include the file location in the query in the normal SELECT format as in:

SELECT * FROM table_name

?