LPJ wrote:

> But this is a table column...i have to put this table column in a variable ?

No, that was just a small but complete and working example. Of course
you can use e.g.


WITH XMLNAMESPACES (DEFAULT
'http://schemas.microsoft.com/powershell/2004/04')
SELECT valores.value('(/Objs/Obj/Props/S[@N = "MachineName"])[1]',
'nvarchar(20)') AS MachineName
FROM diario.eventlog;

assuming your table is diario.eventlog and the XML column is named valores.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/