I think that you will find the XML.value method most useful. Hardly anyone uses OPENXML anymore now that the XML datatype and methods are available.
If you could post an attachment form that would allow us to cut and paste the XML we could probably come up with the proper Xquery. Off hand, I would try something like @xml.value('./vendor[1]/agentNo[1]', 'int')
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]