Grab specific data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Grab specific data

Author

Topic

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2014-08-04 : 04:48:25

<Hello currency 988 v=""/><hello::Value v="0"/><Arrival Code v="ABC"/>
<Hello currency 988 v=""/><hello::Value v="0"/><Arrival Code v="KJHKH"/>
<Hello currency 988 v=""/><hello::Value v="0"/><Arrival Code v="POJ"/>
<Hello currency 988 v=""/><hello::Value v="0"/><Arrival Code v="AKJFISM"/>
<Hello currency 988 v=""/><hello::Value v="0"/><Arrival Code v="PM"/>

how can i only grab the arrival code?

newColumnArrivalCode
ABC
KJHKH
POJ
AKJFISM
'
'
'
'

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-04 : 06:27:09

Is it an XML document or a string value?

Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA