
create table xmltab (
 xmlorder xml
)

declare @x xml
set @x = ( select * from openrowset (
 BULK 'c:\temp\order3.xml', single_blob ) as x)
insert xmltab values(@x)

select * from xmltab
 where xmlorder.exist('/Order/LineItems/LineItem[Description="Cola"]') = 1

