Select * from xml

[Puiu]

I have an xml that looks like this:

<Root>

<row>

<F1>04858</F1>

</row>

</Root>

 

The only way I know to select from this and make it look like a select from table is this:

 

declare @xml xml
set @xml = '<Root>
 <row>
   <F1>04858</F1>
 </row>
</Root>'

DECLARE @docHandle int
EXEC sp_xml_preparedocument @docHandle OUTPUT, @xml

select *
from OPENXML(@docHandle, N'/Root/row') WITH (F1 varchar(10)'F1')

 

My question: Is there a simpler way to do that?

Thanks