How to parse xml?

Question

SQL Server

how to parse xml?
for example, there is an xml variable with the line
declare @xml xml
set @xml ='file.txt 2817 parse
it to be
File name: file.txt
Size: 2817 bytes

Answer 1

So this is not xml, but a regular varchar. And you can
declare @xml VARCHAR(50)
set @xml ='file.txt 2817'
SELECT substring(@xml,0,PATINDEX('% %',@xml)),substring(@xml,PATINDEX('% %',@xml),LEN(@xml))