darma teja

darma teja

  • 1.3k
  • 490
  • 229.4k

IN clause on SQL-Column-datatype-XML

Jul 16 2019 10:22 AM
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.
  1. Select *  
  2. from tbCustomer  
  3. where xmlColumn (Address/street/NoIN (1, 2, 3) 
 
 How can I achieve this?
 
Thanks
Darma

Answers (3)