darma teja

darma teja

  • 1.4k
  • 494
  • 235.9k

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)