Skip to content

string-search-in-xquery.md

Latest commit

 

History

History
64 lines (54 loc) · 2.04 KB

string-search-in-xquery.md

File metadata and controls

64 lines (54 loc) · 2.04 KB
title String Search in XQuery | Microsoft Docs
ms.custom
ms.date 03/04/2017
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
applies_to
SQL Server
dev_langs
XML
helpviewer_keywords
strings [SQL Server], search
XML [SQL Server], searching text
searches [SQL Server], XML documents
XQuery, string search
ms.assetid edc62024-4c4c-4970-b5fa-2e54a5aca631
caps.latest.revision 23
author JennieHubbard
ms.author jhubbard
manager jhubbard

String Search in XQuery

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]

This topic provides sample queries that show how to search text in XML documents.

Examples

A. Find feature descriptions that contain the word "maintenance" in the product catalog

SELECT CatalogDescription.query('  
     declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";  
    for $f in /p1:ProductDescription/p1:Features/*  
     where contains(string($f), "maintenance")  
     return  
           $f ') as Result  
FROM Production.ProductModel  
WHERE ProductModelID=19

In the previous query, the where in the FLOWR expression filters the result of the for expression and returns only elements that satisfy the contains() condition.

This is the result:

<p1:Maintenance     
      xmlns:p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain">  
 <p1:NoOfYears>10</p1:NoOfYears>  
 <p1:Description>maintenance contact available through your   
               dealer or any AdventureWorks retail store.</p1:Description>  
</p1:Maintenance>

See Also

XML Data (SQL Server)
XQuery Language Reference (SQL Server)