Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

IN clause on SQL-Column-datatype-XML

Home
Forums

IN clause on SQL-Column-datatype-XML

darma teja

7yAsked Jul 16, 2019, 10:22 AM997

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Priyanka Jain7y ago
Accepted answer
Hi Darman,

you should try query as below
where it_xml_Template.exist('Address/street/No/text()=1001') = 1
0
darma teja7y ago
Thanks @Priyanka Jain

The first query works fine. But I wanted to use the second query, but it is not working.

Here is the query I wrote:

No has number 1001
where it_xml_Template.exist('Address/street/No/text()') = 1001
It return the empty rows. But I have on row in table
0
Priyanka Jain7y ago
Here you can use like query to fetch data from xml fields in 2 ways
SELECT *
FROM tbCustomer
WHERE CAST(xmlColumn AS NVARCHAR(MAX)) like (1) OR
CAST(xml AS NVARCHAR(MAX)) like ('2')
or the other way to find using xml is
SELECT     *
FROM tbCustomer
WHERE xmlColumn.exist('fields/field[@id="Address" and text()=1]') = 1 OR
      xmlColumn.exist('fields/field[@id="Street" and text()=2]') = 1 OR
      xmlColumn.exist('fields/field[@id="No" and text()=3]') = 1
0