Can someone help me Query this

1. Your XML structure is not valid.

2. Then you can try use this code:

DECLARE @str XML = '"http://schemas.datacontract.org/2004/07/Shared.ViewModels.Warehouse">
"http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
1017412
PO Box 19150
1333 S Rustle Rd.
Spokane
88229
Cochrane and Company
2020-05-06T00:00:00
'
;WITH XMLNAMESPACES('http://schemas.datacontract.org/2004/07/Shared.ViewModels.Warehouse' AS PS1)
SELECT @str.value('(/PS1:CompanyInfo/PS1:ExpDate)[1]', 'varchar(max)')