LISTING 1: OpenXML Query

SELECT NAME, STATE
FROM OpenXML(@docHandle,’//author’)
     WITH (NAME, varchar(30), ‘name’,
           STATE, varchar(2), ‘residence/state’)
WHERE STATE = ‘UT’