get id - Post.Byes

X

sadara

New Member

Join Date: Oct 2007

Posts: 3
#1

get id

Jul 23 '10, 06:42 AM

i want ti get id but field contain value like this <IncidentID=2 0>

i want to get 20 only

how can i get this
Tags: None
code green

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 1726
#2

Jul 23 '10, 08:08 AM

It depends on how consistent the structure is.
But a combination of CHARINDEX and SUBSTRING should do it
Comment
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#3

Jul 23 '10, 05:02 PM

Are you reading a table or an XML?

~~ CK
Comment
amitpatel66

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 2358
#4

Jul 26 '10, 03:43 PM

In case if thats an XML, can you post the complete xml message that would help us better and provide more efficient solution?
Comment

Previous template Next

Working...