[DUG] [OFF-TOPIC] MSSQL 2000/2005/2008 Stored procedure to parse xml

[Conor Boyd]

I don't know how you've done it in Delphi, but for parsing XML, I'd use
xpath syntax searching (e.g. via the MSXML library or similar).

Maybe you could try googling for xpath and sql stored procedures?

C.

-----Original Message-----
From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz]
On Behalf Of Leigh Wanstead

I got data like this in the sql column. How do I parse inside sql stored
procedure to get the value "me"? Any code please. I have no trouble to
parse the value in Delphi 7. But I want to see how can I do it inside
stored procedure?

<hello>
	<hi> me </hi>
</hello>