Query with XML help - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Query with XML help

Message

From

28/01/2011 13:05:46

Daniel Majtczak
Pb
Pine Brook, New Jersey, United States

To

28/01/2011 12:58:30

Sergey Berezniker
New York, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Query with XML help

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01497674

Message ID:

01497695

Views:

36

The following returned what I needed:

CAST(XMLInString as XML).value('(/pbXML/Shipment/BillNr)[1]', 'varchar(10)')

Thanks again for your help,
Daniel

Click here to load this message in the networking platform