IN clause on SQL-Column-datatype-XML

Question

I have an XML text in the column(e.g column name:  xmlColumn in Customer tabel)

I am searching based on xpath (Address/street/No) and using IN operator.

Select *
from tbCustomer
where xmlColumn (Address/street/No) IN (1, 2, 3)

 

 How can I achieve this?

 

Thanks

Darma